SQL SELECT IN SELECT

by Online Tutorials Library July 22, 2022

SQL SELECT IN SELECT

When a select from where expression is insufficient to express a complex query, a sub-query as a select from where expression can be nested within another query.

Let’s take an example to explore it completely:

We have to found all customers who have both an account and a loan at Mohan Nagar branch.

 SELECT distinct customer_name FROM borrower, loan WHERE borrower.loan_number   = loan.loan_number and Branch_name =Mohan Nagar and (branch_name, customer_name) IN (SELECT branch_name, customer_name From depositor, account Where depositor .account_number = account.account_number) 

Next TopicSQL Select Null

SQL SELECT IN SELECT

SQL SELECT IN SELECT

What is Akka

Swift Ternary Conditional Operator

You may also like