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

what is the impact analysis?

1918


*) Internal review defect gets detected… 1) During peer review. 2) By the own stuff member onsite/offshore. 3) During Informal review process. 4) None of these 5) All of these

1852


Have you ever completely tested any part of a product? How?

2034


Why testers wil prepare useracceptance testcases,system testcases and integration testcases,What is the differenece between all this test cases

1618


What is common interface?

1521






How to explain the Insurance project in the interview?

1097


How will you do beta testing?

644


what comments have u given in peer review? tell me at least 3 comments what u have given? july27 brahma412@yahoo.co.in

1515


What is client server application testing?

1552


Can you please explain about the erp project

1422


How do i write a test condition to test the following simple program with the intention of 100% statement coverage Print “Hello World” If Date $ = ‘01-01-2000’ then Print “Happy New Year” END IF PRINT “The date is = “Date $ PRINT “The time is = “Time $ END Could anyone please clarify in detail. Would really appreciate it....

1638


What are the Major Functionality for a ATM machine ??

5009


How will you determine when to stop testing?

631


what is TAS language which is used as a language for some projects/

1601


how to connect oracle with test director? in testdirector we will be getting only reports? pls answer Thanks in Advance

1420