Write a query to find second highest salary of an employee.
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
What is Ticketing tool? Has it any other names? What is the purpose of this?
How do you choose which automation tool is best for your specific scenario?
What are the differences between open source tools, vendor tools, and in-house tools?
Hi everyone, Are you looking for "worksoft certify" automation tool training online? We have experienced corporate Worksoft certify trainers. We also provide support Worksoft certify automation issues. Please contact us Automationsolutions@yahoo.com
What is a framework and what are the frameworks available in rc?
Do you know the difference between close and quit command?
Which package can be imported while working with webdriver?
Elaborate the situation where automation testing can’t be used for agile methods?
can any one tell me the examples of white box testing
What is the different between GUI map and GUI map files?
I am fresher and i have completed my software testing course and i don't have real time experience,can anybody help me regarding financial domain projects,main testcases in that domain.
When you will not automate testing?
Do you know what is a xpath?
Which test cases can be automated?
how to test an webbased application?