how to get top two salaries from employee tables

Answer Posted / varu

This will be right answer for the query

Select * from empsal e where 2<=(select count(*) from empsal f
where e.sal>f.sal) order by sal desc

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is revision history and the content of revision history table?

1565


What is smoke testing and what is sanity?

649


What is a code walk through?

662


What is Pre UAT and UAT is there any difference ?

2982


What is reverse engineering?

751






could anyone explain application testing in sequence order i don't have any experience in that

1527


write test cases on wall

1725


I want to do certification in ISTQB please anybody hepl me with the details and site to refer for further details.............if possible give me the material as well on my mail id a.vishwakarma@aol.com. Please help me........Thanks

1696


What icon is used in WinRunner to get an explanation of the syntax of TSL?

1571


What is the difference between Functional testing and Unit Functionality testing?

1536


Hi Friends, I want to know the best institute in hyderabad which is giving training in 'SAP Testing' and who is the best faculty. Regards, Imtiyaz..

2557


Iam new to testing field and i put lot of experiences so i want to get prepared for the interview in all the ways both in manual and Automation can any one help me how to answer there questions in real time. also can anyone send the top questions and answers to me plz its urget u can mail me at vaisu72@yahoo.com

1467


What is your daily process? I have 2+EXP IN MANUAL TESTING.PLEASE SUGGEST ME HOW i ANSWER

1820


test cases on bangles???

2557


what is localization and globalization.and what are the ways way are going to test the particular application?how can we identify factual, visual, corrupted characters, link errors, formatting errors, etc in locallization?iam going to attend the interview on localization concepts and languages like : German, Japanese, French, Russian, Italian, Chinese, Korean, Portuguese and Spanish .tell me the process how to do testing above concepts let me know its urgent:anilaluvala@gmail.com 9908814046

1598