MSSQL
Aus CrazyLinux
This query gives you the same ability as a LIMIT clause does in MySQL and Oracle for MS SQL Server without the headaches of stored procedures or temp tables.
SELECT * FROM (
SELECT top 10 emp_id,lname,fname FROM (
SELECT top 30 emp_id,lname,fname
FROM employee
ORDER BY lname ASC
) AS newtbl ORDER BY lname DESC
) AS newtbl2 ORDER BY lname ASC
SELECT top 10 emp_id,lname,fname FROM (
SELECT top 30 emp_id,lname,fname
FROM employee
ORDER BY lname ASC
) AS newtbl ORDER BY lname DESC
) AS newtbl2 ORDER BY lname ASC
from: http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=850&lngWId=5
