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

Answer Posted / n.tejaswi

Select Empname
from emp LIMIT 2
orderby empsal;

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why automation testing?

585


why should we choose VSTET(Visual Studio Team Edition for Testers) and not QTP?pleas give me the reasons for "WHY" we have web and client server app, supports power builder and on windows OS so this is the background of tech and envir things we have and now VSTET is good to use or not? if "NO" then tell me why

1774


Any kind of test which you think should not be automated?

525


On Test Complete I recorded some keyword test. while I'm running the batch test, if one test case failed, then how test complete skip the failed test case and again continue to run the test case? please provide some way to resolve this issue.

1546


Do you know the difference between close and quit command?

488






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?

2129


Have you completed the cps exam? Which one?

534


Give some examples for defect management tools?

558


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

1423


What is the process of Automation Testing?

565


write a programme to insert into elements in array?n finding duplicate characters in given sting?

1793


What is junit annotation?

536


Tell us what is the difference between single slash (/) and a double slash ( //) in xpath?

631


I want to learn the data base testing, how can I start my psactice? I already reading the books of basic for data base? If any other books that make my study simple please suggest.

1553


Tell me what is a keyword-driven framework?

500