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

how to find the second highest salary from emp table?

Question Posted / anurag kumar rai

Answer Posted / anurag kumar rai

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the use of triggers?

1084

Is primary key is clustered index?

1045

How do I order by ascending in sql?

1081

What are sql data types?

1072

What is rownum and rowid?

1077

How to use sql statements in pl/sql?

1196

What is the difference between stored procedure and view?

1067

What is difference between sql function and stored procedure?

1063

What is optimistic concurrency control? : Transact sql

1032

What is composite data type in pl sql?

1170

what is a cursor? : Sql dba

1066

Can we rollback after truncate?

1073

What is dense_rank in sql?

1046

can sql servers linked to other servers like oracle? : Sql dba

1054

How do you update sql?

1039