πŸ“Š MySQL
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

πŸ‘οΈ
79
Total Visits
πŸ“½οΈ
12 mo ago
Published
πŸŽ–οΈ
Praveen Singh
Publisher
πŸ“ˆ
93%
Success Rate