Select Chapter ❯

MySQL Tutorial

MySQL Introduction
MySQL Connection
MySQL Create DB
MySQL Create Table
MySQL Data Types
MySQL Indexing
MySQL Query DB
MySQL Operators
MySQL Clauses
MySQL Join
MySQL Union
MySQL Subquery
MySQL Transaction

MySQL Subquery

Subquery is another query that is coded with in another query.You can code the subqueries in WHERE, HAVING, FROM or SELECT clause of a SELECT statements.

Example of Subquery

SELECT student_name from student_info where student_id = 
(SELECT id from student_marks where total_marks > 90 )

Code Explanation

In this example it select student_name from student_info table where the value of student_id is given by subquery

❮ Prev Next ❯

All TalkersCode Topics

Follow TalkersCode On Social Media

MySQL Tutorial

MySQL Subquery

Example of Subquery