SQL - Select command summary 2 of 2

• Defines the order the result set is to be sorted.
• If a list of columns is specified the sort will occur on the first field, then second, etc..
• Examples
  • Select * From Employees Order By Address2, LastName, FirstName;

• These include; Count, Avg (Average), Max, Min, Sum.
• Examples
  • SELECT COUNT(*) FROM Employees; (Returns the number of Employee records)
  • SELECT MAX(Salary) FROM Employees; (Returns highest earner)
  • SELECT MIN(Salary) FROM Employees;
  • SELECT AVG(Salary) FROM Employees;
  • SELECT SUM(Salary) FROM Employees;

• May be supported by your SQL package, or may have equivalent functions.
• String functions; SUBSTRING, UPPER (UCASE in Access), LOWER and TRIM.
• Examples
  • SELECT * FROM Employees WHERE UPPER(LastName) = UPPER("Bloggs");
  • SELECT * FROM Employees WHERE LOWER(LastName) = LOWER("Bloggs");
  • SELECT * FROM Employees WHERE SUBSTRING(LastName FROM 1 To 3) = "Ran";
  • SELECT * FROM Employees WHERE TRIM(Leading "B" From LastName) = "loggs");
  • SELECT * FROM Employees WHERE TRIM(Leading " " From LastName) = "Bloggs");
  • SELECT * FROM Employees WHERE TRIM(TRAILING " " From LastName) = "Bloggs");
  • SELECT * FROM Employees WHERE TRIM(BOTH " " From LastName) = "Bloggs");

• Standard SQL works with the ANSI standard which is a US date format mm/dd/yyy.

(1997, Mar) Evans, M
[Rev:20/04/99] 27 Mar 97 © 1997-99 V/2-Com (Verhaart), P O Box 8415, Havelock North, New Zealand.