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 / 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
Explain dotnet framework ?
Explain about continuable exceptions?
Tell me .net mobile emulators? : Microsoft dot net mobile
How to improve the cache performance? : Dot net architecture
Differences between VS 2005, 2008 and 2010 ?
How to prevent my .NET DLL to be decompiled?
What is private constructor? And it's use?
Explain the five stages in a dlx pipeline? : Dot net architecture
Can I create my own metadata attributes?
How do we do authentications using atlas?
What is the use of CLR in .NET?
What is .net mobile images control. : Microsoft dot net mobile
What are relation objects in dataset?
What is Com Callable wrapper?when it will created?
what are login controls?