Multiple choice technology databases

The Correct Statement to select all the columns from a table named "Employee".

  1. SELECT *.Employee

  2. SELECT [all] FROM Employee

  3. SELECT * FROM Employee

  4. SELECT Employee
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The asterisk () in SQL acts as a wildcard that represents all columns in a table. 'SELECT * FROM table_name' is the standard syntax to retrieve every column from the specified table. Options A and B use incorrect syntax ('.Employee' places the wildcard incorrectly, and '[all]' is not valid SQL syntax). Option D is missing both the column specification and FROM clause.

Keep practicing — related questions