Interested to Buy Any Domain ? << Click Here >> for more details...
how to calcuate the second highest salary of he employee
- 13 Answers
- 19009 Views
- Synechron, I also Faced
- E-Mail Answers
Answer Posted / vinayak jamdar
Select top 1 empid,salary from (select distinct top 2
empid,salary from emp order by salary desc)a order by salary
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How do you identify a primary key?
What is the difference between database trigger and stored procedure?
Does oracle use sql?
What is percent sign in sql?
how to extract a unit value from a date and time? : Sql dba
What are character functions?
What are sql queries used for?
Mention what plvcmt and plvrb does in pl/sql?
Can a foreign key have a different name?
Why indexing is needed?
What is case function?
Explain ttitle and btitle.
Is hadoop a nosql?
How do you bind variables in pl sql?
What is embedded sql in db2?
