SQL SELECT Command Overview

SQL SELECT Command Overview - 1 SQL SELECT Command Overview...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
1 SQL SELECT Command Overview Content SQL SELECT COMMAND The focus of the Select Command is on the  retrieval of data  that is already stored in  the database An SQL Select  statement  is composed of several " clauses ". The primary clauses and  keywords are listed below. Only the  SELECT  and  FROM  clauses are required.  SELECT  [Distinct]  fieldname1, fieldname2, …fieldnameN | * (list of desired fields) FROM   tablename (name of table(s) that contain fields. ) WHERE   row selection criteria (criteria for selection of rows) GROUP BY  fieldname1,  fieldname2,… (used to group rows for group functions such as Max, Average) ORDER BY   fieldname1,fieldname2,… (fields to sort by) HAVING   group selection criteria        (criteria for selection of groups) Row selection criteria  are specified as one or more Boolean expressions, joined by  AND or OR.  Examples of row criteria are:             fieldname = ‘ character   string’    (note single quotes) or fieldname =  value
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/21/2011 for the course CGS 2545 taught by Professor Markllewellyn during the Summer '10 term at University of Central Florida.

Page1 / 2

SQL SELECT Command Overview - 1 SQL SELECT Command Overview...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online