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
- 13285 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
What are .net mobile controls features? : Microsoft dot net mobile
how to create applications by using Visual Studio 2012?
how can we achieve language interoperability through CLS? How MSIL works?
Explain dma? : .NET Architecture
Explain the number or character entered through keyboard gets converted to equivalent ascii code & it get stored on ram in the binary form. What is the exact procedure on hardware that converts the ascii value to binary? : .NET Architecture
What is the purpose of cache? : Dot net architecture
what is the difference between master page and content page?
What is the purpose of cache? How is it used? : Dot net architecture
Can I create my own metadata attributes?
How do we do authentications using atlas?
So what exactly is the configuration file for then?
What is the mesi? : Dot net architecture
Explain the number or character entered through keyboard gets converted to equivalent ascii code & it get stored on ram in the binary form. What is the exact procedure. : Dot net architecture
Difference between throw exception and rethrowing ?
What is cache coherency and how is it eliminated? : Dot net architecture
