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

how to find the second highest salary from emp table?

Question Posted / harish

Answer Posted / harish

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is trigger with example?

1170

How do I truncate a sql log file?

1136

what is a table in a database ? : Sql dba

1090

what are date and time data types? : Sql dba

1028

Is primary key always clustered index?

1064

What is a call statement? Explain with an example.

1069

What is foreign key sql?

1039

What is flag in sql?

1099

How do you rank data in sql?

1069

What is a sql schema used for?

1155

How do I delete a trigger?

1015

Does mysql_real_escape_string prevent sql injection?

995

What is the difference between distinct and unique in sql?

993

What is the sql case statement?

1055

Can we use rowid as primary key?

1044