Access SQL - II

Syntax of SELECT clause:

SELECT {* | expression1 [AS alias1][, expression2 [AS alias2][,..]]]}

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;

Previous slide

Next slide

Back to first slide

View graphic version