On Mon, 15 Dec 2003 09:32:34 -0800, Roderick A. Anderson wrote: > want to ask if the LIMIT modifier is SQL standard?
No. The standard doesn't have anything like that, unfortunately. > MS SQL Server uses a TOP modifier. Yes, but it accepts an optional "WITH TIES" modifier which PostgreSQL doesn't have. See also: http://troels.arvin.dk/db/rdbms/#select-limit -- Greetings from Troels Arvin, Copenhagen, Denmark ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings