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

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

Question Posted / monika

Answer Posted / monika

Is This Answer Correct ?

8 Yes

6 No

Please Help Members By Posting Answers For Below Questions

what are date and time intervals? : Sql dba

1100

What is pls integer?

1089

What is rank dense_rank and partition in sql?

1084

What do you mean by query optimization?

1048

Show the cursor attributes of pl/sql.

1099

what is a database transaction? : Sql dba

1255

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

1011

What are the types of records?

1034

How do you take the union of two tables in sql?

1027

What is t-sql? : Transact sql

1039

Why sql query is slow?

1040

what is a stored procedure? : Sql dba

1189

How to write html code in pl sql?

1158

What does pragma mean?

1129

What is sql server and ase?

1066