LIke WHERE (2)
SELECT Id FROM testTabel2 test1 WHERE (2) = ( SELECT COUNT(DISTINCT(test2.Id )) FROM testTabel2 test2 WHERE test2.Id >test1.Id )
SELECT * FROM ( SELECT ID, ROW_NUMBER() OVER(ORDER BY ID Desc) AS RowNo FROM Table1) AS T WHERE RowNo = 2
SELECT TOP(1) ID FROM ( SELECT TOP(2) ID FROM Table1 ORDER BY ID DESC) AS T ORDER BY ID ASC
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)