Question

Which of these query will display the the table given above ?

(a) Select employee from name

(b) Select name

(c) Select name from employee

(d) Select employee

This question was posed to me in an internship interview.

My enquiry is from SQL Queries topic in chapter SQL : Queries, Constraints and Triggers of Database Management

Answer 1

Right answer is (c) Select name from employee

Easiest explanation - The field to be displayed is included in select and the table is included in the from clause.