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 / malli

Answer Posted / malli

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can we call stored procedure in function?

959

how can you create an empty table from an existing table? : Sql dba

1154

How to call a javascript function from pl sql?

1143

What is the difference between pl and sql?

1093

which types of join is used in sql widely? : Sql dba

982

How do I view tables in mysql?

986

how to calculate expressions with sql statements? : Sql dba

1034

Is left join same as inner join?

1130

How to download oracle sql developer?

1110

What are types of exception?

922

How are sql commands classified?

1089

What is a pl/sql block?

1230

How do I view a procedure in sql?

974

What are the ways on commenting in a pl/sql code?

1135

Which sql statement is used to delete data from a database?

959