Big Data with Spark - Flat 33% OFF   Offer ends in

SQL Tutorial

37 / 59
   

Inner SELECT

This is a method wherein data from which we need to select something doesn't come from a table directly, rather from the output of another inner select query.

The output of inner select serves as a table for outer select.

select count(1) from (
select empfname from emp) a;