sql - How to resolve "No column was specified for column 1 of 'r'"

Question

Closed. This question needs details or clarity. It is not currently accepting answers. question from:https://stackoverflow.com/questions/65840267/how-to-resolve-no-column-was-specified-for-column-1-of-r

Answer 1

Just give alias to your column as follows:

select * from (select rtrim(Emp.s_filterh) my_column_name from Emp, Dept
    where Dept.label = 'xyz' and Emp.filtery=1 and Emp.r_id=Dept.r_id  
    order by 1 desc offset 0 rows ) as r
    where ROW_NUMBER < 26 

Note: Always use the standard ANSI joins.