LIMIT modifier

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
-- 
    "Open Source Software - You usually get more than you pay for..."
     "Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL"