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

WHAT IS CARDINALITIES OF JOIN?

0 Answers  

Which is the best sorting method if i have to sort the students of Harvard University according to their first name?

1 Answers   CybAge,

What is the use of graph database?

0 Answers  

write a query for the fifth highest salary?

17 Answers   IBM, Matlabs, Ramco,

Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.

0 Answers   Amazon,

HOW PASS PARAMETERS FOLLOWING ORDER RPG-CL-RPG?

0 Answers  

HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?

0 Answers  

Is it possible to update AS400 database record while reading it with no lock

1 Answers  

What is Data Modelling?

0 Answers   Informatica,

how to configure oracle 10g in java1.5 and tell me know how to set class path in system?

0 Answers  

What will happen non-clustered index will be created on clustered index?

0 Answers   Abacus,

What is the difference between data source and database?

0 Answers