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

Answer Posted / sweety spear

select *from emp e1 where &n =(select count(*) from emp
where sal >= e1.sal);

Is This Answer Correct ?    13 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me which web driver implementation is the fastest?

526


is there any one got offer from snapdeal?

4147


Can you do without a framework?

616


is anybody suggest me which one is the best testing institute in ameerpet hydrabad

1744


Give some examples of priority – severity defect levels.

541






How to select an automation tool best matched for your project?

519


Tell us how can we handle web-based pop-up?

573


in keyword driven frame work..where Driver Script is locate? is there any inbuilt script for driver script?who writes the driver script?how to call it any body can tell me with an example...like(yahoo login,inbox, logout).

1679


HOW CAN WINRUNNER AND TEST DIRECTOR CONNECTED TO THE DATABASE AND WHAT R THE OPTIONS?

1468


what is nTier Architecture understanding what is Microsoft ASP.net, ASP and SQL understanding what is Web Application and eCommerce application understanding what is Unit, System, Regression, FAT testing ? Test Automation and Test Script Authoring

2522


can anyone suggest me any low cost tool that can support both Manual and Automation testing ?

1503


Name the frameworks that are used in software automation testing?

542


Explain me how to check if an element is visible on the page?

527


How can the user get a text of a web element?

535


What is an automation testing framework?

586