In SQL, which of the following syntax is correct for selecting unique row?

  • A. SELECT UNIQUE name FROM tblcustomer
  • B. SELECT ATOMIC name FROM tblcustomer
  • C. SELECT DISTINCT name FROM tblcustomer
  • D. None correct

Answer: Option C