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

How can get second highest salary in sql?

929

What is difference between inner join and cross join?

926

How do you get column names only for a table (sql server)?

1116

give the syntax of grant and revoke commands? : Sql dba

1107

What is trigger and stored procedure in sql?

989

What is delimiter sql?

942

How to connect a sql*plus session to an oracle server?

1092

What is the primary use of normalization?

963

What are data types in pl sql?

1096

How do you break a loop in pl sql?

1003

What is the use of function "module procedure" in pl/sql?

1158

What does t sql mean?

916

Does a user_objects view have an entry for a trigger?

975

How many rows can sqlite handle?

1068

What is the difference between view and stored procedure?

925