how to get top two salaries from employee tables
Answer Posted / satya
Hi,
Select * from emp e where 2>=(select count(*) from emp e
where sal>e.sal) order by desc sal.
Let me know if this query is wrong.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How can I done a Web Testing? Which steps are include in it?
can anyone tell me few critical bugs in ecommerce project.
Can you explain steps in function points?
What is a defect age?
What is smoke test?
what is quality Factor
wat is meant by frontend and backend testing
Where we have to use perl scripting in Testing approach and its importance
what r the measure bugs found in your project??? Give some example abt this.
What is CVS and why it is used?
How to integrate Bugzilla with QTP?
how agile testing is performed and what are the related documents.
What is Registry?
I am a ISTQB cerfity tester with 3 yrs experience(kolkata) , I left my current commpany due to some problem but since two months I did not get new job , why? is my age is 33 yrs and I am married . If anybody have any answer please let me know, my email id sangitadas1981@gmail.com/yahoo.co.in
Hi, Anybody knows about Hexaware company..