select * from (select salary from employees order by salary desc)where ro

how to get second highest salary in SQL(as/4000

Question Posted / sachin bhalsinge

Answer Posted / sachin bhalsinge

select * from (select salary from employees order by salary
desc)where rownum=2;

Is This Answer Correct ?

5 Yes

11 No

Please Help Members By Posting Answers For Below Questions

What is query execution plan in sql?

1184

Why use subqueries instead of joins?

1078

What are the two types of exceptions in pl/sql?

1048

Why do we need view in sql?

982

what is primary key? : Sql dba

1023

How do you delete data from a table?

1025

What is dialect in sql?

942

how to use regular expression in pattern match conditions? : Sql dba

1026

What is a pdo connection?

1028

What is a parameter query?

1075

Can function return multiple values in sql?

1051

What is the sql*loader? : aql loader

1050

What has stored procedures in sql?

1064

What does (+) mean in sql joins?

1059

What is bind variable in pl sql?

1051