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
19806 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

What is user defined datatypes and when you should go for them?

966

What the different types of Replication and why are they used?

981

Why we use the openxml clause?

956

How to delete a database in ms sql server?

1120

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

982

How can a database be repaired?

925

You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

119

What is a trigger in sql server?

1094

What is the size of transaction log file?

871

What are drillthrough reports?

141

Some queries related to SQL

937

Difference between LEN() and DATALENGTH() in sql server ?

1062

What is ms sql server index?

1026

What are data resources?

855

What do you mean by cardinality?

849