SQL with Jupyter Notebook Tutorial

27 / 61

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.

%%sql
select count(1) from (
select empfname from emp_<<your lab username>>) a;

No hints are availble for this assesment

Answer is not availble for this assesment

Loading comments...