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

Is redis in memory database?

0 Answers  

List the properties of a transaction.

0 Answers  

what are wrappers and build ups and what it's use?

0 Answers   TCS,

How to do Stored procedure testing? Who does this testing (Developer or tester)?

0 Answers  

What are the three types of anomalies in database and Explain?

9 Answers  

how to implement dense rank in rank transformation in Informatica? so that output should be like 1,1,2,3 and not like 1,2,3,4

1 Answers  

What is the best database software for small businesses?

0 Answers  

Explain entity type?

0 Answers  

What is the importance of database partitioning?

0 Answers  

Explain file manager?

0 Answers  

What do you mean by foreign key and primary key?

0 Answers   Zensar,

Clipper / DBF error

1 Answers