In SQL, What syntax is correct for filtering seller name’s dara or male?

  • A. SELECT * FROM tblclerk WHERE name = ‘dara’ | gender = ‘male’
  • B. SELECT * FROM tblclerk WHERE name = ‘dara’ || gender = ‘male’
  • C. SELECT * FROM tblclerk WHERE name = ‘dara’ OR gender = ‘male’
  • D. None correct

Answer: Option C