Share Blog

Friday, January 29, 2016

Select first,Second Row Data In SQL Server

How to display serial number or we can say record/row number Data In sql server




SELECT TOP 1 * FROM DigiNews WHERE ID NOT IN ( SELECT TOP 1 ID FROM DigiNews ORDER BY ID desc )ORDER BY ID desc


No comments:

Post a Comment