CodesJava

Easy learning with example program codes

what do you mean by subquery?


A subquery refers to a select statement that is embedded in a clause of another select statement.
Syntax

SELECT columnName1, columnName2
FROM   tableName1, tableName2
WHERE  columnName OPERATOR
   (SELECT columnName
   FROM tableName1, tableName2
   [WHERE])

Example:

SELECT id, first_name 
FROM student_details 
WHERE id IN (SELECT student_id
FROM student_subjects 
WHERE subject= 'IT'); 

Related topics

Posted in SQL   


Copyright © 2018 CodesJava DMCA.com Protection Status SiteMap