Started with a Basic SELECT Statement

If you haven’t used SQL before, or don’t really feel like you’ve really understood it yet—pay attention
here! The SELECT statement and the structures used within it form the basis for the lion’s share of all the
commands we will perform with SQL Server. Let’s look at the basic syntax rules for a SELECT statement:
SELECT <column list>
[FROM <source table(s)>]
[WHERE <restrictive condition>]
[GROUP BY <column name or expression using a column in the SELECT list>]
[HAVING <restrictive condition based on the GROUP BY results>]
[ORDER BY <column list>]
[[FOR XML {RAW|AUTO|EXPLICIT|PATH [(<element>)]}[, XMLDATA][, ELEMENTS][, BINARY
base 64]]
[OPTION (<query hint>, [, …n])]

Wow—that’s a lot to decipher, so let’s look at the parts.

Twitter Widgets Facebook Widgets

For Further Reading:

Leave a Comment


Previous post:

Next post: