SQL

• SELECT: table headings or *

  FROM: table

  WHERE: query / condition
• eg

  SELECT *

  FROM TableName

  WHERE compsci = 9
• eg

  SELECT studentName, English

  FROM GradesTable

  WHERE studentName = "Dion"
• SELECT PupilID, First Name, Merit Points

  FROM Pupil

  WHERE First Name = ‘Amy’ OR Merit Points > 60;