Interested to Buy Any Domain ? << Click Here >> for more details...
How to find 6th highest salary from Employee table ?
- 10 Answers
- 23959 Views
- I also Faced
- E-Mail Answers
Answer Posted / krishan kant
SELECT MIN(SALARY) FROM EMPLOYEE WHERE SALARY IN (SELECT
DISTINCT TOP 6 SALARY FROM EMPLOYEE ORDER BY SALARY
DESC)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is index fragmentation in ms sql server?
How use inner join in sql server?
What are translations and its use? : sql server analysis services, ssas
How to manipulate data from one table to another table ?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
How is sql used in sql server?
How do I create an extended event in sql server?
What are pessimistic lock and optimistic lock?
What is trigger explain with program?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
What is the xml datatype?
What is intellisense?
What is difference between order by and group by?
how to define testing of network layers? : Sql server database administration
optimization techinques
