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
hi, kindly send WWF(.net 3.5) pdf notes to my id. thanx in advance, chays
What are the different pipelining hazards? : Dot net architecture
Explain about metadata?
Explain pipelining? : Dot net architecture
What is an interrupt? : Dot net architecture
What is the purpose of hard disk? : Dot net architecture
Explain different pipelining hazards and how are they eliminated? : .NET Architecture
where should I put this information then?
What are end points, contract, address and bindings?
Differences between VS 2005, 2008 and 2010 ?
Whate are resource files? How are they used in .net?
Do you know textbox and textview controls of .net mobile? : Microsoft dot net mobile
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.
What is WPF and WCF?
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.....