Question

oracle和sql server取第一条记录的区别以及rownum详解

Answer 1

oracle
select * from T where rownum = 1;
sql server
select top 1 * from T;