select max(sal)from emp where sal in(select sal from emp minus select max(s

how to find the second highest salary from emp table?

Question Posted / gurvinder

Answer Posted / gurvinder

select max(sal)from emp where sal in(select sal from emp minus select max(sal) from emp);

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the advantage of index in sql?

972

What is rowid in sql?

987

What are the various levels of constraints?

1125

What is primary key and foreign key?

962

What is right join in sql?

1092

what are enums used for in mysql? : Sql dba

1170

How do I count records in sql?

1009

What is a system versioned table?

987

What is the difference between syntax error and runtime error?

1142

What is multiple partition?

968

Write a sql select query that only returns each name only once from a table?

1016

Can sql function call stored procedure?

1025

Can I call a procedure inside a function?

1012

What is a database trigger?

1071

Explain how can you save or place your msg in a table?

1028