In SQL, which is correct about order by name in table tblclerk?

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

Answer: Option C