Question

A subquery in an SQL SELECT statement

Answer 1

Assuming table name student and table columns roll no, class and marks

SQL statement with subquery:-

SELECT * FROM STUDENT
WHERE MARKS BETWEEN 60 AND 85;


Here subquery is between , you might have studied about this query in your book.

hope it helps you