for the first one:
select e1.empname,sal from emp_table e1
where (21=(select count(*) from emp_table e2 where e1.sal<e2.sal));
Thanks&Regards,
Bhargavi
1.
Type: Posts; User: bhargaveereddy; Keyword(s):
for the first one:
select e1.empname,sal from emp_table e1
where (21=(select count(*) from emp_table e2 where e1.sal<e2.sal));
Thanks&Regards,
Bhargavi
1.