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 the difference between Delete and Truncate command in SQL

1199

List some case manipulation functions in sql?

1090

How many columns can we include on clustered index ?

1058

What is server-level principal?

122

Is null in sql server?

1042

What are key, name and value columns of an attribute? : sql server analysis services, ssas

1066

What is sharding?

116

Explain the categories of stored procedure?

979

You want to implement the many-to-many relationship while designing tables. How would you do it?

1046

How to remove duplicate rows from table?

1311

What is code near application topology?

283

What is mean by dml?

1060

What do you mean by recursive stored procedure?

990

What is a transaction and why is it important?

1162

How many types of built in functions are there in sql server 2012?

966