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

This is an exact duplicate of question 139506. SELECT * from EMP; is correct syntax where * selects all columns from the EMP table.

Keep practicing — related questions