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

Explain data independence & its types.

0 Answers  

what is data set ?

1 Answers  

What is the function of cluster index?

0 Answers   Alcatel-Lucent,

What is meant by distributed system?

0 Answers  

can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?

0 Answers  

CLI stands for?

3 Answers   IBM,

What is a database string?

0 Answers  

What is a sequence? Explain it with one example?

0 Answers   BirlaSoft,

How do you select an index for a table

1 Answers  

What is lagging in DBMS ?

0 Answers   Hexaware,

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

0 Answers  

What is the difference between oracle and MS Access?

0 Answers   Alcatel-Lucent,