Sybase ASE 入門 select での TOP と Order By

きちんと、order by した後に 上位から select してくれます。

create table ot (number int)
insert into ot values (4)
insert into ot values (3)
insert into ot values (2)
insert into ot values (1)
insert into ot values (5)

select top 2 * from ot order by number
select top 2 * from ot order by number desc

### result
 number      
 ----------- 
           1 
           2 

(2 rows affected)
 number      
 ----------- 
           5 
           4 

(2 rows affected)