SQLRef / Quick Reference / Commands / S / SELECT
SQLRef Menu:
  • Quick Reference:
  • My Bookmarks
Enter a specific command or browse:

| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | All |

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

Detailed Instructions For:
SQLRef Designed by Quentin Smith, © 2001-2003
Email the webmaster.
348119 hits since January, 2001.

Creative Commons License
This work is licensed under a Creative Commons License.