June 19, 2012

Sql query to get second top record from table

Sql query to get second top record from table

select top 1 *from customers where id NOT IN ( select top 1 id from customers order by id ) order by id

No comments:

Post a Comment