select empname,salary from( select empname,salary, rank() over( order by

To find second largest salary in Employee table

Question Posted / sujith

Answer Posted / sujith

select empname,salary from(
select empname,salary, rank() over( order by salary desc) ss from emp)
where ss=2;

Is This Answer Correct ?

3 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How do I install only the client tools of sql server 2000?

555

Explain the steps to create and execute a user-defined function in the sql server?

535

What is meant by indexing files?

583

What is named calculation? : sql server analysis services, ssas

535

What are the advantages of using third-party tools?

556

List out the different types of locks available in sql server?

562

what are the disadvantages of cursors? : Sql server database administration

496

What is #table in sql server?

539

What is an execution plan? How would you view the execution plan?

551

What is user defined stored procedures?

570

What is side by side migration in sql server?

545

Explain error handling in ssis?

573

Explain primary key in sql server?

571

What are the advantages of stored procedure in sql server?

470

How to use clusters?

555