Use the below SQL statement

select employee_id first_name last_name from employees a where &n (select count(salary) from employees b where a.salary < b.salary)

Regards

Rajasekhar.N

select emp_id emp_name sal from employee a where &n (select count(distinct(salary)) from employee b where a.sal < b.sal)

&n 22 ( U will be asked to enter the number and then enter for which record u want to retrieve)

a.sal < b.sal (this can be used to retrieve max record)

a.sal > b.sal( this can be used to retrieve min record)

for 1 question the query is

select level max(sal) from employees

wherelevel &level

connect by prior sal>sal

group by level; here u should mention level as22

2)delete from employees where positionnumber 39andcommision<100;

For the 1st question

Select * from emp where sal (Select * from (select sal from emp order by sal desc) group by sal having rownum 22)

Hi

For the 1st Question:
Ans:- Select a.sal from emp a where 29 (select count(distinct(b.sal)) from emp b Where a.sal< b.sal)
For the 2nd Question:
Ans:-Delete from Employee where Positionnumber 39 and Commission<100;
For the 3rd Question:
And:-update employee set recno 45;

Thanks

Parvathi.

To find out the 22nd highest salary

use this query

select * from employee e1

where

(select count(distinct(salary)) from employee e2

where e2.salary>e1.salary) (22-1)

since there must only be 21 salaries above this

First question:

select min(salary) from (select distinct salary from employee order by salary desc) where rownum< 22);

or

select max(salary) from (select distinct salary from employee order by salary asc) where rownum< 22);

second question:

delete from employee where emp_id 39 and comm<100;

Third question

update table employee set recno 45;

SELECT * FROM (SELECT rownum r A.* FROM
(SELECT
l.* FROM employee l ORDER BY l.empsal DESC) A)

WHERE B.R '4' )

2) I want to delete a person with position
number 39 with commission < 100
DELETE FROM emp WHERE posno 39 and comm < 100


3) Update
record number is 45
UPDATE emp WHERE recno 45