Multiple choice technology databases

To select all the columns from a table EMP, which one of the following is TRUE?

  1. Select all columns from EMP;

  2. Select distinct columns from EMP;

  3. Select * from EMP;

  4. All of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

SELECT * from EMP; is the correct SQL syntax to select all columns. The asterisk (*) wildcard represents all columns in the table.

Keep practicing — related questions