In SQL, which of the following syntax is correct about order by?

  • A. SELECT * FROM tblcustomer ORDER BY name WHERE name = ‘sok’
  • B. SELECT * FROM tblcustomer WHERE name = ‘sok’ ORDER name
  • C. SELECT * FROM tblcustomer WHERE name = ‘sok’ ORDER BY name
  • D. None correct

Answer: Option C