how to get top two salaries from employee tables

Answer Posted / charan

hi this is charan,
select e1 *from employees e1
where 2>
( select column(distincte2.sal)
where e2.sal>e1.sal )

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can any1 tell me suppose u r doing manual testing on unix platform with Shell Script, then how it is done? How u r implementing it & what is the use of Shell scripting on Manual Testing?

3576


Scenario-based testing Option 1 concentrates on actor and software interaction Option 2 misses errors in specifications Option 3 misses errors in subsystem interactions Option 4 Both 1 abd 2

3155


How do you perform configuration management with typical revision control systems?

1737


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

1872


Can u give me explanation about section 508 testcase and Testcase for this section. It need a details checklist for the same Manimozhi

2364






Please explain how to elaborate on the types of system/functionality for testing Payments, Statements, & Transactions features in a bank.....like what do we test in these,in detail? It's urgent, please reply...thanks in advance.

2126


How do u determine,what to be tested?

1709


what are the status have in QC(Test Management Tool). and how you report?

1546


What is difference between web site testing, desktop application testing and wireless application testing? what is the difference in testing strategy to test them?

1693


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

1594


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

1705


What is system level testing?

789


a newly launched web site is hosted on web server.It is expected that 100 people visit the website every hour and browse 30 pages spending a total 15 minutes. what is the maximum hits/sec that the web server should support this load?justify your answer. need urgently. by rimesh

1505


What are the different ways to check a date field in a website?

771


On login window for username and password auto populated field means what !

1354