Which SQL command is primarily used to retrieve data from a database table?

Options

  • A. GET
  • B. SELECT
  • C. FETCH TABLE
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

B. SELECT

Detailed Explanation

  • SELECT retrieves data from one or more database tables.
  • The WHERE clause filters records based on specified conditions.
  • Example: SELECT * FROM students;