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
What is textview control of .net mobile? : Microsoft dot net mobile
how to change row background color in gridview
how to delete the record using data reader
What is IL code, CLR, CTS, GAC & GC?
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.....
What is .net mobile input validation. : Microsoft dot net mobile
Can you Explain
Tell me .net mobile emulators? : Microsoft dot net mobile
Can you explain server controls in atlas?
What are the options provived by vss to the user? how it will help us while delevoping application?
Can you explain scriptmanager control?
i wish to write mcts(microsoft certified technology specialist) exam. can anyone give the model question or format and preparation method?
HttpHendler and HttpModules
How cache coherency is eliminated? : Dot net architecture
IS IT Possible to inherit the AJAX page from child class which(child) is inherit from page class.Because i should apply some security in child class