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

how to find the second highest salary from emp table?

Question Posted / sudha

Answer Posted / sudha

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is a unique key ? : Sql dba

1151

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1228

What is primary key sql?

1112

Are stored procedures faster than dynamic sql?

1106

Is stored procedure faster than query?

1021

What is the maximum number of triggers, you can apply on a single table?

1048

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1108

What is sap sql?

1030

Why do we need cursors in pl sql?

1160

Can a varchar be a primary key?

1049

What is sqlerrm?

987

can a stored procedure call itself or recursive stored procedure? : Sql dba

1086

Does sqlite need a server?

1097

Why do we need cursor in pl sql?

1187

What is the command used to fetch first 5 characters of the string?

1467