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 aggregate functions in sql?

1114

How do you go back in sql?

958

does sql support programming? : Sql dba

1008

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

923

What is rtm stands for?

1048

What is an escape character in sql?

999

Can you have more than one key in a database?

902

What is t sql in sql server?

1026

Why do you partition data?

986

What are the usages of sql?

1030

how to use myisamchk to check or repair myisam tables? : Sql dba

928

What is use of term?

1020

How to start oracle sql developer?

1001

What are the syntax and use of the coalesce function?

1138

Is foreign key mandatory?

962