Interested to Buy Any Domain ? << Click Here >> for more details...
How to find 6th highest salary from Employee table ?
- 10 Answers
- 23961 Views
- I also Faced
- E-Mail Answers
Answer Posted / vj
with cte as
(
select dense_rank() over (order by salary desc)
maxSal ,* from Employee )
select * from cte where maxSal=6
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to write a query with a full outer join in ms sql server?
Explain the types of indexes.
What is the server name for sql management studio?
Define inner join in sql server joins?
What are number line correlation administrators will use while working with a subquery?
What extended events?
What is buffer cash and log cache in sql server?
What is single-user mode?
What are the instances when triggers are appropriate?
What is the Difference Between Primary and Foreign Key?
What are null values in ms sql server?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
Write a program using SQL queries to find a unique entry in a table.
What are the advantages of stored procedure in sql server?
Explain the first normal form(1nf)?
