select MAX (sallary) from emp where sallary<=(select MAX(sallary) from e

how to find the second highest salary from emp table?

Question Posted / amol

Answer Posted / amol

select MAX (sallary) from emp where sallary<=(select MAX(sallary) from emp)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how to rename an existing table in mysql? : Sql dba

1114

How to use sql*plus built-in timers?

1260

What are views in sql?

1037

What are the benefits of triggers?

1217

Why do we need cursor in pl sql?

1187

What is clustered index sql?

1030

What kind of join is join?

1009

What is function and procedure in pl sql?

1116

What is the best sql course?

1026

What is primary key sql?

1107

How does left join work in sql?

1039

How do I run a sql query in pgadmin 4?

999

Is pl sql better than sql?

1086

What is difference between table and view?

1134

Can delete statement be rollbacked?

1031