Q. What will be the output of the following MySQL command?
SELECT emp_id, fname, lname
FROM employee
WHERE title=’HEAD TELLER’;

  • (A) All columns
  • (B) Only those columns which are mention with "SELECT" clause
  • (C) Columns mention with "SELECT" clause and only those rows which contain 'HEAD TELLER' as a "title"
  • (D) None of the mentioned
πŸ’¬ Discuss
βœ… Correct Answer: (C) Columns mention with "SELECT" clause and only those rows which contain 'HEAD TELLER' as a "title"
Explanation: This MySQL command is used to retrieve information from a table called "employee".
Explanation by: Praveen Singh
This MySQL command is used to retrieve information from a table called "employee".

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
137
Total Visits
πŸ“½οΈ
2 y ago
Published
πŸŽ–οΈ
Praveen Singh
Publisher
πŸ“ˆ
84%
Success Rate