Home » MYSQL » Select Query » Question
  1. What will be the output of a query given below?
    SELECT Employee_id, FirstName, LastName
    FROM person;
    1. Show all columns except (Employee_id, FirstName, LastName)
    2. Show all rows
    3. Show only columns (Employee_id, FirstName, LastName)
    4. Show only columns (Employee_id, FirstName, LastName) and rows related to these columns
    5. None of these
Correct Option: D

“SELECT” clause is used to show all rows and columns that are mention with the query.



Your comments will be displayed only after manual approval.