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

If the master device is full, how do I make the master database bigger?

0 Answers  

what is transaction state, buffer management, shadow paging

0 Answers  

What is the best database software for small businesses?

0 Answers  

What is the differnce between Order by and Group by

1 Answers  

issues involved in modeling and building data werahouses

0 Answers  

Is database a hardware or software?

0 Answers  

WHAT TYPE OF JOINS RETURNS INCORRECT RESULTS?

2 Answers   HP,

What is database bounce?

0 Answers  

WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE?

0 Answers  

Explain various types of locks in a transaction? Which is better and why?

0 Answers   Agilent,

what is difference between delete and truncet ?

7 Answers   Fidelity,

What is database schema name?

0 Answers