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

characters of DBMS A) non redundant B) data independence C) increased security D) all the above

1 Answers   Accenture, XP,

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

0 Answers  

What do you mean by database?

0 Answers  

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

0 Answers   CGI,

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

0 Answers   Agilent,

What is the difference between specialization and generalization?

0 Answers   BirlaSoft,

What is the difference between primary key, foreign key and candidate key?

0 Answers   Ernst Young,

diff b/w inter process and in process

0 Answers   Aptara, TCS,

List some advantages of dbms.

0 Answers  

What is database and its types?

0 Answers  

How to implement database security?

0 Answers  

List the properties of a transaction.

0 Answers