Posts tagged sql

SELECT next, last row or “LIMIT-command” in MSSQL

May 26th

Posted by yussi ariefiyono in sql

SELECT previous row or "LIMIT-command" in MSSQL

SELECT TOP (1) FROM table_name WHERE (ID< @ID)
ORDER BY ID DESC

SELECT next row or "LIMIT-command" in MSSQL

SELECT TOP (1) FROM table_name WHERE (ID> @ID)
ORDER BY ID

Thank also for the descussion

sql