Artificial Intelligence (AI) & Machine Learning Course for Managers

 Enroll Now

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;