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

Write a query to find second highest salary of an employee.

Question Posted / arif saulat

Answer Posted / arif saulat

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is information schema in sql?

1054

Is sql the best database?

957

What is a schema sql?

1127

How do you exit in sql?

1096

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

985

What is cursor and why it is required?

1165

Explain select statements in sql?

1043

How delete all data from all tables in sql?

933

What is difference between primary and secondary key?

1009

Can we call dml statement in function?

1027

What is transaction control language (tcl)?

1116

When you have to use a default "rollback to" savepoint of plvlog?

1171

How many clustered indexes can you have?

950

Difference between table function and pipelined function?

1003

What are different types of functions in sql?

991