write a query for the fifth highest salary?
Answer Posted / 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))
Is This Answer Correct ? | 6 Yes | 7 No |
Post New Answer View All Answers
After normalization, what are the conditions which have to keep in mind to de-normalize it?
can u combine pipeline parallelism and partition parallalism? how and whan?
Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.
define primary key index, bitmap index, hash index,virtual indwx
Explain the record term used in database.
Hi, I want do a course in DWH Informatica Administrator and Abinito Administrator please tell me some institute in chennai and i am searching for a job,so please help me and my mail id : satty_rh@yahoo.co.in Thanks, Kumar
aht is the difference b/w network & hierarchial & relational dbms????
How is image stored in database?
How to do Data integrity testing? Who does this testing (Developer or tester)?
what are wrappers and build ups and what it's use?
how to configure oracle 10g in java1.5 and tell me know how to set class path in system?
Is it good to store images in database?
Explain the field term used in database.
You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?
can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?