select max(e1.salary) from Emp_table e1 where e1.salary not in (select max

how to find the second highest salary from emp table?

Question Posted / mohan rathour

Answer Posted / mohan rathour

select max(e1.salary) from Emp_table e1 where e1.salary not
in (select max(e2.salary) from Emp_table e2 )

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is pessimistic concurrency control? : Transact sql

1084

What is indexes?

1056

Is time a data type in sql?

901

Does sql support programming?

1064

List the different type of joins?

1059

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

956

How would you convert date into julian date format?

1001

what is a trigger? : Sql dba

1024

Does truncate release storage space?

1072

what is single byte over head in oracle..?

2398

What are the string functions in sql?

971

What is a string data type in sql?

1036

What is the use of sqlerrd 3?

941

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3044

Why is pl sql used?

977