How to select the nth row in a SQL database table?

I'm interested in learning some (ideally) database agnostic ways of selecting the *n*th row from a database table. It would also be interesting to see how this can be achieved using the native functionality of the following databases: - SQL Server - MySQL - PostgreSQL - SQLite - Oracle I am currently doing something like the following in SQL Server 2005, but I'd be interested in seeing other's more agnostic approaches: WITH Ordered AS ( SELECT ROW_NUMBER() OVER (ORDER BY OrderID) AS RowNumber, OrderID, OrderDate FROM Orders) SELECT * FROM Ordered WHERE RowNumber = 1000000 Credit for the above SQL: [Firoz Ansari's Weblog][1] **Update:** See [Troels Arvin's answer][2] regarding the SQL standard. *Troels, have you got any links we can cite?* [1]: https://web.archive.org/web/20101103031717/http://weblogs.asp.net/Firoz/archive/2005/06/12/411949.aspx [2]: https://stackoverflow.com/questions/16568/how-to-select-the-nth-row-in-a-sql-database-table#42765