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

find out the second highest salary?

Question Posted / karthikeyan

Answer Posted / karthikeyan

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

Is This Answer Correct ?

7 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are a collation and state the different types of collation sensitivity?

1176

11. Display the client number and name and the client number and name of the person who referred that client.

2342

What is the difference between truncate & delete command?

1189

How to invoke the data pump export utility?

1193

What privilege is needed for a user to query tables in another schema?

974

What is meant by joins? List out the types of joins.

1033

What is oracle thin client?

1029

What is recycle bin in Oracle?

1154

What is the difference between Delete, Truncate and Drop in Oracle?

1132

What is the usage of save points in oracle database?

965

How to open and close an explicit cursor in oracle?

1059

Which environment variables are absolutely critical in order to run the OUI?

2122

How to use group functions in the select clause using oracle?

1076

How many types of table in Oracle?

1129

What is an oracle database?

1048