select语句是否属于Transact-SQL(T-SQL)类是Microsoft和Sybase对SQL的专有扩展

select语句是否属于Transact-SQL(T-SQL)类是Microsoft和Sybase对SQL的专有扩展。

MS T-SQLselect: http : //msdn.microsoft.com/en-us/library/ms189499.aspx

SELECT [ ALL | DISTINCT ] [TOP ( expression ) [PERCENT] [ WITH TIES ] ] < select_list > [ INTO new_table ] [ FROM { <table_source> } [ ,...n ] ] [ WHERE <search_condition> ] [ <GROUP BY> ] [ HAVING < search_condition > ] 

ANSI SQLselect: http : //www.rawos.com/odbc/sqlguide/index.html

 SELECT [DISTINCT|ALL] *|{attr_name[ AS new_attr_name]} FROM {table_or_view[ alias]} [ WHERE where_criteria] [ GROUP BY {attributes}[ HAVING condition]] [ ORDER BY {attrname|attrorder [ASC|DESC]}] [ INTERSECT|UNION[ ALL] SELECT_statement] 

是的,T-SQL Select是ANSI Select的扩展(因此可能是专有的)版本。