SQL> desc table_name
Name Null? Type
----------------------------------------- -------- --------------
ID NUMBER(1)
NAME VARCHAR2(8)
SQL> select * from table_name ;
ID NAME
---------- --------
1 one
2 two
3 three
select max(decode(seq,1,name,0)) first,
max(decode(seq,2,name,0)) second,
max(decode(seq,3,name,0)) third
from ( select id,name,row_number() over ( partition by 1 order by id ) seq
from table_name
)
where seq <=3
group by 1
;
|