Answer / arshi

SELECT MAX(Salary) AS Expr1
FROM TableName
WHERE (Salary NOT IN
(SELECT TOP (4) MAX(Salary)
AS Expr1
FROM TableName AS
TableName_1
GROUP BY Salary
ORDER BY SalaryDESC))

Answer / ramesh

select top 1 salary

(select distinct top 5

salary from employees

order by salary desc)

a order by salary

Answer / sujit

Hop it helps!

Select sal from (select sal from emp order by sal desc
where rownum<6);

Answer / payal

select salary from emp order by salary desc limit 4,1

Answer / aravind

select * from (select sal from emp order by desc) emp where
rownum = 5

Answer / p.chella vijaya

select top 5 (salary) from emp order by desc

Answer / p.chella vijaya

select top 5 (salary) from emp order by salary desc

Write a query to get maximum and second maximum in oracle?

0 Answers   CGI,

What does specialization in DBMS mean?

0 Answers   BirlaSoft,

What is difference between data and database?

0 Answers  

What is database collection?

0 Answers  

What is sqlcode -923 ?

1 Answers  

Differentiate between unique key and foreign key?

0 Answers   CGI,

Is database a hardware or software?

0 Answers  

Differentiate between delete and truncate table?

0 Answers  

What does new grouping sets enables you to do?

0 Answers   ADITI,

What is difference between clustered, non-clustered and unique index?

0 Answers   Abacus,

CLI stands for?

3 Answers   IBM,

HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?

0 Answers