select * from (select a.*,dense_rank() over (order by sal) rnk from emp a o

how to find the second highest salary from emp table?

Question Posted / dakshin

211 Answers
368418 Views
CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
E-Mail Answers

Answer Posted / dakshin

select * from (select a.*,dense_rank() over (order by sal) rnk from emp a order by sal) where rnk =2

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is dml and ddl?

959

How to change the order of columns in Oracle SQL Plus ?

1058

What are the parameter modes supported by pl/sql?

1112

What is having clause in sql?

969

What are the different types of triggers?

1138

Mention what pl/sql package consists of?

1002

What is difference sql and mysql?

992

Is sql free?

974

What is the purpose of a secondary key?

979

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

2280

Why do we use sqlite?

985

How do you know if a relationship is 2nf?

946

What are all the different normalization?

1044

What does the hierarchical profiler does?

1061

How can we make an if statement within a select statement?

1015