|
Syntax of SELECT clause:
|
|
SELECT {*|expression1[ASalias1][,expression2[ASalias2][,..]]]}
|
|
Example: SELECT *
|
|
SELECT LastName
|
|
SELECT [Customer#], LastName, FirstName
|
|
Syntax of FROM clause:
|
|
FROM table-or-query [AS alias]
|
|
Example: SELECT * from tblOrder;
|
|
SELECT OrderId, OrderDate FROM tblOrder as [Orders Table];
|
|
Syntax of WHERE clause:
|
|
WHERE expression1 [{And|Or} expression2[..]]
|
|
Example: SELECT OrderId FROM tblOrder WHERE OderTakerId = 2;
|
|
SELECT OrderId, OrderDate FROM tblOrder WHERE Sex="Female" AND Age BETWEEN 21 AND 29;
|
|
Syntax of ORDER BY clause:
|
|
ORDER BY column1 [{ASC|DESC}][,column2[{ASC|DESC}][,..]]
|
|
Example: SELECT * FROM tblCustomer ORDER BY LastName, FirstName;
|
