A

Admin • 833K Points
Coach

Q. Is there any error in the following MySQL statement?
SELECT e.emp_id, e.fname,e.lname,d.name
FROM employee AS e INNER JOIN department AS d
ON e.dept_id=e.dept_id;

  • (A) NO
  • (B) All columns but only those rows which contain 'HEAD TELLER' as a "title" and start_date are greater than 2013-01-24
  • (C) DEPEND
  • (D) None of the mentioned
  • Correct Answer - Option(A)
  • Views: 21
  • Filed under category MySQL
  • Hashtags:

Explanation by: Admin

This question asks if there's an error in a MySQL query. Let's break down the query and see if anything is wrong:

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.