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 are types of indexes in sql?

1083

What are the types of operators available in sql?

1062

how to select unique records from a table? : Sql dba

1113

what are ddl statements in mysql? : Sql dba

1201

Write a unique difference between a function and a stored procedure.

998

Is sql injection illegal?

1025

How do you know if a relationship is 2nf?

946

how can we optimize or increase the speed of a mysql select query? : Sql dba

948

How do I edit a stored procedure?

992

What is a pragma statement?

1263

What is a procedure in pl sql?

1212

Define concurrency control. : Transact sql

1192

What is sql entity?

1107

What are records give examples?

1010

Which one is faster ienumerable or iqueryable?

934