Write a query to find second highest salary of an employee.

Answer Posted / p

select ename from emp where esal=(select max(esal) from emp
where esal<(select max(esal) from emp));

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why automation testing?

604


When will you not automate testing?

612


What are the advantages of test automation?

580


Tell me how can the user get a text of a web element?

522


List down the primary features of a good automation tool?

520






Is ui level testing possible?

560


Once you identify the tool what would be your next steps?

590


if i want to use different values in datatable with each iteration of for loop what would i do ??/

1654


Types of F/w in Automation

841


How could the web element attributes be inspected in order to use them in different locators?

543


How can you switch back from a frame?

540


How do you identify the test cases which are suitable for automation?

562


Hi I need the following information about JMeter 1) How many(max) threads(users) can hit the website using Jmeter? 2) How long(in hours) can we run Jmeter for stress test? (Is there any “Memory full” issue if we run for long time?) 3)What typeof sampler to use for clicking on the link?

2144


In Selenium how a test suit is run and report is generated.

1570


What are the disadvantages of Hybrid framework

5692