WITH CTE as (select emp_id,salary,rn=row_number() over (order by salary

Find out the 3rd highest salary?

Question Posted / nikhilesh roy

Answer Posted / nikhilesh roy

WITH
CTE as
(select emp_id,salary,rn=row_number() over (order by salary desc) from emp_table )
select * from CTE where rn=3;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are three advantages to using sql?

958

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1132

What is mutating trigger?

968

Is primary key clustered index?

897

What does 0 mean in sql?

910

What is a scalar value in sql?

1010

What is the difference between instead of trigger and after trigger?

947

What is a database trigger?

1016

What is a system versioned table?

927

What is nvarchar max in sql?

959

what are the advantages of sql ? : Sql dba

999

How can I get the number of records affected by a stored procedure?

999

how to escape special characters in sql statements? : Sql dba

966

What are the different ddl commands in sql?

1064

What are schema-level triggers?

1045