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 / sathish
select max(Salary)from employee where Salary not in (select
max(Salary)from employee )
select min(Salary)from employee where Salary not in (select
min(Salary)from employee )
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
i wish to write mcts(microsoft certified technology specialist) exam. can anyone give the model question or format and preparation method?
What is IL code, CLR, CTS, GAC & GC?
What is .net mobile lists. Explain with an example? : Microsoft dot net mobile
12. Types of polymorphisem[Run and Design Exp.]
What are the types of memory management? : Dot net architecture
what are constructors and destructors?
What happens when you try to update data in a dataset in .net while the record is already deleted in sql server as backend?
What is Video Streaming in .net??
6. Wcf- what is SOA
What is .net mobile forms? : Microsoft dot net mobile
What is difference between Desktop, Client Server & Web based applications?
Difference between throw exception and rethrowing ?
Differences between VS 2005, 2008 and 2010 ?
What is an interrupt? : .NET Architecture
How do I know when my thread pool work item has completed?