select *, row_number() over (order by cid desc) as num from items select * from (select *, row_number() over (order by cid desc) as RowNum from items) t2 where t2.RowNum=5 ...
INNER JOIN (SELECT * FROM Sales.SalesOrderDetail d1 WHERE d1.SalesOrderDetailID = (SELECT TOP 1 SalesOrderDetailID FROM Sales.SalesOrderDetail d2 WHERE d2.SalesOrderID = d1.SalesOrderID ORDER BY ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback