Select 语句 oracle /MSSQL 对比

MSSQL 语法

 

SELECT [ALL | DISTINCT] {select_list}                                 
                    [INTO [owner.]table]                               
                    [FROM [owner.]{table | view}[alias]                 
                    [HOLDLOCK]                                          
                    [,[owner.]{table | view }[alias]                    
                    [HOLDLOCK]]...]                                     
                    [WHERE condition]                                    
                    [GROUP BY [ALL] aggregate_free_expression         
                    [, aggregate_free_expression]...]                  
                    [HAVING search_condition]                           
                    [UNION [ALL] SELECT...]                             
                    [ORDER BY {[[owner.]{table | view }.]column          
                    | select_list_number | expression}                  
                    [ASC | DESC]                                       
                    [,{[[owner.]{table | view }.]column |              
                    select_list_number | expression}                   
                    [ASC | DESC]...]                                   
                    [COMPUTE row_aggregate(column)                     
                    [,row_aggregate(column)...]                        
                    [BY column [, column...]]]                         
                    [FOR BROWSE]                                       
                    The individual element in the select list         
                    is as follows:                                    
                    [alias = ]                                         
                    {* | [owner.]{table | view}.* | SELECT ...        
                    | {[owner.]table.column | constant_literal |
                   expression}
                    [alias]}

 

oracle语法

 SELECT [ALL | DISTINCT] {select_list}
 FROM [user.]{table | view } [@dblink]
[alias]
[, [user.] {table | view3} [@dblink]
[alias]...
[WHERE condition]
[CONNECT BY condition [START WITH
condition]]
[GROUP BY aggregate_free_expression
[,aggregate_free_expression]...]
[HAVING search_condition]
[ {UNION [ALL] | INTERSECT | MINUS} SELECT
...]
[ORDER BY {expression | position} [ASC | DESC]...]
[FOR UPDATE [OF [[user.]{table |
view}.]column
[,[[user.]{table | view}.]column... ]
[noWAIT] ]
The individual element in the select list is
as follows:
{ * | [owner.]{table | view | snapshot |
synonym}.* | {[owner.]table.column |
constant_literal | expression }
alias]}