For 2nd maximum salary select Max(sal) from EMP a where 2=(select COUNT(di

how to find the second salary?

Question Posted / vamsi krishna

Answer Posted / vamsi krishna

For 2nd maximum salary
select Max(sal) from EMP a where 2=(select COUNT(distinct(sal)) from EMP b where a.SAL<=b.SAL);

Is This Answer Correct ?

14 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What guidelines should be followed to help minimize deadlocks?

868

What is a subquery in a select query statement in ms sql server?

1063

What is a select query statement in ms sql server?

1006

how to determine the service pack currently installed on sql server? : Sql server database administration

906

What stored by the master?

903

What do you understand by recursive stored procedure?

872

How do I change my passwords (database, LDAP, and so on) without causing an outage?

1015

What is onf in normalization form?

998

What are commit and rollback in sql?

1050

Explain logical operators in sql server?

1031

Can I use sql azure as a backup with log shipping or database mirroring?

156

What is extent? Types of extents?

1086

What are the different types of data sources in ssrs?

187

Mention what are the core components of ssrs?

296

Explain the creation and execution of a user-defined function in the sql server?

993