how to calcuate the second highest salary of he employee
- 13 Answers
- 16648 Views
- Synechron, I also Faced
- E-Mail Answers
Answer Posted / vivek ghorad
select min(select top(2)salary from emp)from emp;
| Is This Answer Correct ? | 3 Yes | 9 No |
Post New Answer View All Answers
Does mysql support pl sql?
What is sqlca in db2?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
Difference between table function and pipelined function?
What is pls integer?
Explain the structure of pl/sql in brief.
What is offset and limit in sql?
Is t sql a programming language?
What schema means?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
What are all the ddl commands?
Is microsoft sql free?
What are variables in pl sql?
what is 'mysqlimport'? : Sql dba
explain the advantages and disadvantages of stored procedure? : Sql dba
