next up previous contents index
Next: UPDATE Up: Muchos comandos SQL mas... Previous: INSERT   Índice General   Índice de Materias

SELECT

Sintáxis:

        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]];



Ismael Olea 2001-04-21