with SalCTE (EMPID,Ename,Sal,Num)as (select *,row

Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed)

Question Posted / veeresh kethari

with SalCTE (EMPID,Ename,Sal,Num)as

(select *,row_number() over(order by sal desc) num from emp)

select * from SalCTE where Num=4

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is a covered index?

889

Do you know sql server 2008 backup compression?

919

what are isolation levels? : Sql server database administration

908

What is difference between view and materialized view?

885

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

843

What are the types of user defined functions in sql server?

988

Why truncate is ddl command?

992

Can a table be moved to different filegroup?

917

How to enter comments in transact-sql statements?

891

Can sql servers linked to other servers?

971

Do you know query execution plan?

1071

What is an indexed view?

915

what's new in sql server 2016?

905

When do you think a developer should use sql server-based cursors?

975

Define the one-to-one relationship while designing tables.

855