select e.employee_id from employees e where
(select count(*) from employees f where f.employee_id < e.employee_id) < 5;
The above query gives me first five employee id's. I want to know about the output produced by the sub query and explain. Thanks in advance.