Developers of Sympa

[Dominique ROUSSEAU <address@concealed>]

On Fri, Apr 21, 2000 at 09:58:45AM +0200, Olivier Salaun - CRU wrote:
> 
> I know MySQL's syntax is :
> 
>       SELECT ...FROM...WHERE...[ORDER BY column] [LIMIT [offset,] rows]
> 
> What is the format for other DBMS ? ie :
> 
>       o PostgreSQL

sympa=> \h select
Command: select
Description: retrieve tuples
Syntax:
        SELECT [DISTINCT [ON attrN]] expr1 [AS attr1], ...exprN
        [INTO [TEMP] [TABLE] class_name]
        [FROM from_list]
        [WHERE qual]
        [GROUP BY group_list]
        [HAVING having_clause]
        [ { UNION [ALL] | INTERSECT | EXCEPT } SELECT ...]
        [ORDER BY attr1 [ASC|DESC] [USING op1], ...attrN ]
        [FOR UPDATE [OF class_name...]]
        [LIMIT count [OFFSET|, count]];

Which gives the same syntax. I think, it's (almost) SQL92 standard.

>       o Oracle
>       o Sybase
> 
> Thanks        
> 
> Olivier Salaun
> Comite Reseaux des Universites

--
Dominique Rousseau <address@concealed>          
Neuronnexion - http://www.neuronnexion.com