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

To find second largest salary in Employee table

Question Posted / anu

Answer Posted / anu

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is sql server a database?

539

How to throw custom exception in Stored Procedure?

583

What to perform pattern match with the like operator?

488

What is the default port for SQL Server over a firewall?

593

What is candidate key with example?

518

What is sql profiler. What are the default templates with it? : sql server database administration

523

What is the maximum length of an alert name?

606

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

Explain the properties of sub-query in sql server?

514

Tell me can we use custom code in ssrs?

601

How do I open a .db file?

484

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

535

How to provide values to user defined function parameters?

557

Why does sql studio use a single registered database repository? : sql server management studio

536

Explain view in sql server?

626