find the 3rd max salary

Answer Posted / cpnagar

select top 1 salary from(select distinct top 3 salary from
emp order by salary desc)as e order by e.salary

Is This Answer Correct ?    7 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between deallocate cursor and close cursor?

728


What is the use of custom fields in report?

561


What is ddl and dml commands?

516


tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

568


How to provide values to stored procedure parameters in ms sql server?

537






What stored by the model?

552


Explain the difference between control flow and data flow?

532


What are the extra roles available in msdb? : sql server security

644


What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

609


How will you make an attribute not process? : sql server analysis services, ssas

589


What is spatial and temporal data?

537


What are the hotfixes and patches in sql server?

548


Explain few examples of RDBMS?

617


What is the use of builtinadministrators group in sql server? : sql server security

538


What is sql server agent and what are the two modes of authentication in sql server?

553