Have a look at the bottom of this page: http://www.postgresql.org/docs/current/static/sql-select.html
"Nonstandard Clauses
The clauses DISTINCT ON, LIMIT, and OFFSET are not defined in the SQL standard."
TOP x isn't in the standard as well, afaik.
Best regards,
Arjen
Roderick A. Anderson wrote:
I'm dealing with a project that requires me to query a MS SQL Server. Not a PostgreSQL issue I know but I want to ask if the LIMIT modifier is SQL standard? MS SQL Server uses a TOP modifier.
select top 1 * from xxx;
Whereas all the SQL RDBMS' I've used before used
select * from xxx limit 1;
Any enlightenment is appreciated. (I'm putting notes in the code to reflect the non-standard stuff I've had to deal with.)
TIA, Rod
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
