Select max(Sal) from emp Where Sal < (Select max(Sal) from emp);

To find second largest salary in Employee table

Question Posted / anu

17 Answers
20408 Views
CSS, I also Faced
E-Mail Answers

Answer Posted / anu

Select max(Sal) from emp
Where
Sal
<
(Select max(Sal) from emp);

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain what are magic tables in sql server?

1000

How to enter binary string literals in ms sql server?

1166

What is difference between standardization and normalization?

1105

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1044

What is the difference between dataadapter and datareader?

1008

What is tablix?

163

Explain differentiate between a having clause and a where clause?

913

How to find table changes in sql server?

1128

What is CTE in SQL

951

How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

2588

Explain a checkpoint?

1042

Explain the difference between control flow and data flow?

1005

How to get the number of affected rows?

1007

How many types of triggers in sql server?

1033

What do you understand by the analysis services in sql server?

943