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
- 13284 Views
- GeoTechnology, Wipro, I also Faced
- E-Mail Answers
Answer Posted / mohsin mukri
select max(salary) as Salary from tbl_Employee
where salary <= (select max(salary) from tbl_employee)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Describe the advantages of writing a managed code application instead of unmanaged one. What is involved in certain piece of code being managed?
What is .net mobile input validation. : Microsoft dot net mobile
Explain the difference between inprocess vs out process session state : Dot net architecture
data types used in validation control
What is Object Caching in Visual Studio 2010?
What's new in the .net 2.0 class library?
Explain about continuable exceptions?
Explain the difference between primary & secondary storage device? : Dot net architecture
So what exactly is the configuration file for then?
any one can explain about projectarchitecture and project approach briefly
What are the major differences between services and web services?
How do I know when my thread pool work item has completed?
Is .net easier than java?
Explain How to improve the cache performance? : Dot net architecture
Explain about generation?
