how to get top two salaries from employee tables

Answer Posted / shiva - e-softsys

SELECT MIN (SALARY) FROM EMP WHERE

SALARY IN (SELECT DISTINCT TOP 2 SALARY FROM EMP ORDER BY
SALARY DESC)

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

i heard that mainframe testing is diff from other environments & has lot of keyboard input????pl clarify my doubt & let me know in what way its diff??

1712


Have you worked in UDAP (Credit Card act 2009) project?What did you test in Billing & Payment modules?

1872


how recovery manager works in winrunner

1644


What if an organization is growing so fast that fixed testing processes are impossible? What to do in such situations?

1068


How do you estimate white box testing?

754






What type of questions will be asking for 2 years experience candidate in manual testing?

1905


what is acid testing?

2220


HI GUYS,, I HAVE 3 YEARS OF EXP IN MANUAL TESTING...NEXT MONTH ONWARDS I WORK FOR MOBILE TESTING....PLS SUGGEST ME WHAT I LEARN FOR TRAING,, MOBILE TESTING OR ANDROID....FOR MOBILE TESTERS NEED ANDROID(IFONE) DEVOLOPMENT KNOWLEDGE OR NOT? EXPLAIN CLEARLY

1803


consider therez 1 land and it has mango trees in it, what are the tets cases or how will we count no of mangoes on all trees

1678


What are parametere require for Performance testing?

2006


how will the test plan is pepared in ur organisation>?

1594


How do you go about testing a project?

1544


Hi,friends i am going to write ICST certificate exam on augest.So can anybody post some of sample qusetions for ICST certificate exam.Really it will be useful for me

1708


I have an UI issue "please fill out this field" pop up in firefox browser keeps scrolling with the page is it valid???

1575


Can you explain a pair-wise defect?

781