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
What is an interrupt? : Dot net architecture
Explain is development of a mobile web application with asp.net is very easy? : Microsoft dot net mobile
Explain cache? : Dot net architecture
Is dim fs as filestreamobject is a managed code? : Dot net architecture
What is the difference between l1 and l2 cache? : Dot net architecture
What is an asssembly qualified name? Is it a filename? How is it different?
Explain write back and write through caches? : Dot net architecture
Can you explain server controls in atlas?
What actually happes when you add a something to arraylistcollection ?
how to change the title of my window?
Can you explain control extenders?
How will you do windows authentication and what is the namespace?
Define dma? : Dot net architecture
What is the purpose of cache? How is it used? : Dot net architecture
What is ILDASM ?