Write a query to find second highest salary of an employee.
- 72 Answers
- 109264 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / satish
select e1.* from emp e1 where 1=(select count(distinct
e2.sal) from emp e2 where e2.sal>e1.sal)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Tell me what criteria do you consider for automating a test?
Give some examples for defect management tools?
How many test cases have you automated per day?
Can any one give me the script for drag and drop or setselection functions ?like in a not pad i want to select 5 lines
Could any one share scripts... where we can Parameterize radio buttons and Check boxes in Rational Robot.
Tell me what type of scenarios can be automated?
Hi all, Do anyone have the experience in PDF Document Automation using OLE objects and methods? If so suggest the best websites for source. Thanks :-)
Why do you prefer selenium automation tool?
Tell us how to select a value in a dropdown?
Tell me an example of the languages supported by webdriver?
Which protocol cam be used to makw jdbc connection woth loadrunner
Tell us what methods of robot class do you know?
Where do we get the QTP and Load runner softwares CDs ( Original ) in chennai
Tell us what you know about table-driven testing?
what is the dictionary objects in QTP? and what is method of vb script using virtual object wizard........
