how to find the 2nd higgest salary in the column for example
take table name is employee?
And also find bottom 2nd lowest salary ?

Answer Posted / arrry.net

Select top 1 salary from tbl_registration where salary in
(SELECT TOP 2 salary from tbl_registration)
order by salary desc

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

hi, kindly send WWF(.net 3.5) pdf notes to my id. thanx in advance, chays

1883


What are the different pipelining hazards? : Dot net architecture

574


Explain about metadata?

522


Explain pipelining? : Dot net architecture

590


What is an interrupt? : Dot net architecture

504






What is the purpose of hard disk? : Dot net architecture

485


Explain different pipelining hazards and how are they eliminated? : .NET Architecture

503


where should I put this information then?

581


What are end points, contract, address and bindings?

525


Differences between VS 2005, 2008 and 2010 ?

574


Whate are resource files? How are they used in .net?

494


Do you know textbox and textview controls of .net mobile? : Microsoft dot net mobile

506


The maximum report processing jobs limit configured by your system administrator has been reached.How I can Solve this problem when i using crystal report to load from my application.

14059


What is WPF and WCF?

573


I am working with asp.net 2005 and Crystal report 10. I have an image field on my dataset to show on Crystal report.And the image is shows dynamically from database in image field of CR. The image field is showing well on my Crystal report on its first page with all other data but when i click to open second page of CR,it does not show any data on that.I found that this is because of adding the image field on crystal report. Because when i remove the image field from the CR then it will run both the pages of CR. I am using the Page Load event to bind CR data with Database. And i have already check with the Init event to bind CR , but it still not shows the data on second page when i use image field on that. Please give solution for that.....

1464