Write a query to find second highest salary of an employee.
Answer Posted / lokesh kanithi
Select * from emp e where 2=(select count(Distinct(esal))
from emp where e.esal<=emp.esal)
| Is This Answer Correct ? | 27 Yes | 22 No |
Post New Answer View All Answers
Please explain what is the hybrid framework?
What are the advantages of the automation framework?
hi to all, if we open a browser(for ex. yahoomail.com) using navigate command. the cursor by default focussing on the 'yahoo id' html edit box. how to get the label(ie.,yahoo id) of that html edit box using descriptive program. here we should not use identify tool to get the property,thtml editbox method. by tracing the cursor position we have to get the label name. is it possible? please let me know.
Do you know what is robot api?
What are the points that are covered while planning phase of automation ?
In Selenium how a test suit is run and report is generated.
What is the Differnce between Client/Server Testing and Web Based Testing?
Tell me how can the user get a text of a web element?
Do you know when autoit is used?
Which protocol cam be used to makw jdbc connection woth loadrunner
Tell me what is the firefoxdriver, class or an interface? And which interface does it implement?
Mention a few good practices while performing automation testing.
What are pros and cons of automating tests at ui layer?
What are the limitations of automating software testing?
how to re-install QTP 11.0 trial version