Admin • 833.24K Points
Coach

Q. The following MySQL statement belongs to which condition types?
SELECT fname
FROM person
WHERE dept_id= (SELECT dept_id FROM department WHERE names=’s’);

(A) Equality condition
(B) mysqlcopydb
(C) Range condition
(D) All of the mentioned

Correct Answer - Option(A)
Views: 30
Filed under category MySQL
Hashtags:

Explanation by: Admin

This MySQL statement uses a subquery to find the department ID of a department named 's' and then selects all the first names (fname) from the person table where the department ID matches the result of the subquery.

You must be Logged in to update hint/solution

Discusssion

Be the first to start discuss.

Mapped Tags:

Tag	Mapped By	Action

Q. The following MySQL statement belongs to which condition types? SELECT fname FROM person WHERE dept_id= (SELECT dept_id FROM department WHERE names=’s’);

Explanation by: Admin

Discusssion

Q. The following MySQL statement belongs to which condition types?
SELECT fname
FROM person
WHERE dept_id= (SELECT dept_id FROM department WHERE names=’s’);