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 / cooldude

Answer Posted / cooldude

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

Is This Answer Correct ?

14 Yes

2 No

Please Help Members By Posting Answers For Below Questions

List the different type of joins?

1113

Explain the difference between triggers and constraints?

1023

What is the difference between partitioning and sharding?

1050

What are the operators used in select statements?

1097

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1065

how to escape special characters in sql statements? : Sql dba

1081

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

1008

What is output spooling in sql*plus?

1089

Which is better trigger or stored procedure?

1014

what happens if null values are involved in expressions? : Sql dba

1092

what is a composite key ? : Sql dba

1101

What are different categories of sql commands?

1194

What is gpt format?

991

What are the syntax and use of the coalesce function?

1273

What is sql in oracle?

1108