how to find the second salary?

Answer Posted / sannnnnnnnnnn

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

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

565


What are the different subsets of sql?

944


What’s the use of custom fields in report?

563


What is molap and its advantage? : sql server analysis services, ssas

537


What are the difference between “where” and “having” clause in sql server?

577






Why functions are used in sql server?

502


What is meant by datasource?

510


What are alternate keys?

569


How can you set the threshold at which sql server will generate keysets asynchronously?

561


what changed between the previous version of sql server and the current version? : Sql server database administration

513


How to delete duplicate rows from table except one?

541


Differentiate between a primary key and a unique key.

586


What is apply operator in sql?

557


what is a schema in sql server 2005? : Sql server database administration

508


What happens when the SQL Azure database reaches Max Size?

90