By using the rank function we can get the 2nd highest salary from the emp

how to find the second highest salary from emp table?

Question Posted / avinav

Answer Posted / avinav

By using the rank function we can get the 2nd highest
salary from the emp table

Is This Answer Correct ?

10 Yes

25 No

Please Help Members By Posting Answers For Below Questions

What is the difference between explicit and implicit cursors in oracle?

1070

Is sql a microsoft product?

954

How many clustered indexes can you have?

975

Is primary key clustered index?

953

What are analytical functions in sql?

1037

What is the use of pl/sql table?

1070

What is the difference between in and between in sql?

1068

What is denormalization in a database?

1060

what is 'mysqlcheck'? : Sql dba

1019

What is scope of pl sql developer in future?

1026

What does select * from mean in sql?

3247

What are schema-level triggers?

1106

What is sql in java?

1096

What is a schema sql?

1161

How does cross join work?

961