select max(sal) from emp where sal<>(select max(sal) from emp);

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / jebitha

Answer Posted / jebitha

select max(sal) from emp where sal<>(select max(sal) from
emp);

Is This Answer Correct ?

7 Yes

9 No

Please Help Members By Posting Answers For Below Questions

Is sqlite thread safe?

1040

What are % type and % rowtype?

1028

describe mysql connection using mysql binary. : Sql dba

1054

Why do we need cursor in pl sql?

1125

What does a pl/sql package consist of?

971

How can a function retun more than one value in oracle with proper example?

1071

Can you have a foreign key without a primary key?

947

Can we use loop in sql?

965

Why is there a need for sqlcode and sqlerrm variables?

1043

What is left join example?

940

What is a call statement? Explain with an example.

996

How do I write a sql query in pgadmin 4?

972

How can you create an empty table from an existing table?

1068

How do you create an update query?

956

How do I truncate a word?

1080