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
- 12499 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
How to upload in video,mp4,in .net 4.5 ..?
data types used in validation control
Explain the difference between inprocess vs out process session state : Dot net architecture
How do I write to the application configuration file at runtime?
Explain the difference between primary & secondary storage device? : .NET Architecture
Explain difference between machine config vs. Web config? : .NET Architecture
8. Oop-Why and were we use Interfacse and Abstract class.
Explain the difference between l1 and l2 cache? : .NET Architecture
Explain the difference between state server and sqlserver : Dot net architecture
What is different about namespace declaration when comparing that to package declaration in java?
Explain the components required to develop mobile applications with .net mobile? : Microsoft dot net mobile
Explain .net mobile input controls? : Microsoft dot net mobile
Define cache coherency and how is it eliminated? : Dot net architecture
What is WPF and WCF?
Does application frame need host?
