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
- 15367 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)
sory above post ans is wrong bcoz i forgot to remove = sign
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain dma? : Dot net architecture
What is new in the .net 2.0 class library?
Define a virtual memory? : Dot net architecture
Explain the difference between state server and sqlserver : Dot net architecture
What are bindings?
Why the config file might not be writable
What is the purpose of Accordian in jquery? Where it can be used?
What is the use of TPL DATAFLOW?
Explain .net mobile events? : Microsoft dot net mobile
What is a virtual memory? : Dot net architecture
What is the difference between .net mobile pages and ordinary .net web page? : Microsoft dot net mobile
8. Oop-Why and were we use Interfacse and Abstract class.
Explain the number or character entered through keyboard gets converted to equivalent ascii code & it get stored on ram in the binary form.
Explain .net mobile selectionlist control? : Microsoft dot net mobile
Explain How to improve the cache performance? : Dot net architecture
