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
- 16057 Views
- GeoTechnology, Wipro, I also Faced
- E-Mail Answers
Answer Posted / prasoon madnawat
SQL Server:
Select MIN(Salery) from (SELECT TOP 2 * from EMPLOYEE)
Oracle:
Select MIN(Salery) from (SELECT * from EMPLOYEE where ROWNUM <3)
MySQL
Select MIN(Salery) from (SELECT * from EMPLOYEE LIMIT 2)
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
What are the main Tools to develop .Net Application?
Different types of authentication modes in .net framework ?
Explain hard disk and what is its purpose? : .NET Architecture
What is the difference between .net mobile pages and ordinary .net web page? : Microsoft dot net mobile
HttpHendler and HttpModules
How do I write to the application configuration file at runtime?
Explain the number or character entered through keyboard gets converted to equivalent ascii code & it get stored on ram in the binary form.
how we can fire event in databound column in datagrid without using button?
Can you explain server controls in atlas?
What is new in the .net 2.0 class library?
what is inheritancy where u required ?
Explain the types of memory management? : .NET Architecture
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.....
How to implement the display in the class printdoc (how to resolve the naming conflict) a: no naming conflicts
Explain different pipelining hazards and how are they eliminated? : Dot net architecture
