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 happens when a trigger is associated to a view?

915

What are instead of triggers?

1046

Does view contain data?

1037

What is the difference between join and natural join?

927

What is data modelling in sql?

1020

How do I run sql?

1187

What is assignment operator in pl sql?

1038

What is the unique index?

1054

how many ways we can we find the current date using mysql? : Sql dba

1099

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1345

How can we make an if statement within a select statement?

1013

What is the difference between rollback and rollback to statements?

1060

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1269

What is partition in sql query?

999

What is a temporal data type?

1052