Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the 2nd higgest salary in the column for example
take table name is employee?
And also find bottom 2nd lowest salary ?
- 11 Answers
- 15791 Views
- GeoTechnology, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sathish
select max(Salary)from employee where Salary not in (select
max(Salary)from employee )
select min(Salary)from employee where Salary not in (select
min(Salary)from employee )
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the Lapsed Listener problem in .net
Explain cache? : Dot net architecture
How is the using() pattern useful? What is idisposable?
What is application frame host?
How to improve the cache performance? : .NET Architecture
How does .net mobile work? : Microsoft dot net mobile
What is difference between .net and visual studio?
How cache coherency is eliminated? : Dot net architecture
What is one way operation?
Explain hard disk and what is its purpose? : Dot net architecture
Whats new features in Visual Studio 2012?
What actually happes when you add a something to arraylistcollection ?
Explain about metadata?
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.
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.....
