with cte as ( select dense_rank() over (order by salary desc) maxSal ,*

How to find 6th highest salary from Employee table ?

Question Posted / vj

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

Please Help Members By Posting Answers For Below Questions

What is sql server profiler trace data file?

1053

What are the types of ssrs?

139

What is the maximum size of sql server database?

947

How to create a new schema in a database?

1075

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

960

Write an SQL query to obtain the 2nd highest salary.

1022

Explain what is lock escalation?

989

What is a natural primary key?

953

List the types of recovery model available in sql server?

873

Why olap is used?

921

Explain cursor as data base object?

977

What is data compression? : sql server database administration

920

Give the query of getting last two records from the table in SQL SERVER?

901

Why use “nolock” in sql server?

985

What is the default fill factor value?

1013