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

Answer Posted / lokesh kanithi

Select * from emp e where 2=(select count(Distinct(esal))
from emp where e.esal<=emp.esal)

Is This Answer Correct ?    27 Yes 22 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me what is the firefoxdriver, class or an interface? And which interface does it implement?

492


Hi, here r some questions, which were asked in Ekaplus, plz process these questions. 1. How we connect with the version?

3387


Can the activities of test case design be automated?

1441


What are the important modules of an automation testing framework?

584


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

2518






What generally is the structure of a framework?

579


How is Jmeter tool very useful in projects when it does not have features like online monitoring,WAN emulation,caching like other performance tools.

1958


Name the frameworks that are used in software automation testing?

538


Tell us what is junit? And what is junit annotation?

529


test cases test wheather window? test cases to test calculaor? test cases to test a reverse string program? test cases to test program{ int.parse(sting str) $return (int)}? test cases to test program{display string length}?

1763


How do i startup with Remedy testing tool. Couldnot able to find any links for startup. Please help me to startup with this remedy tool.

1224


Elaborate the situation where automation testing can’t be used for agile methods?

511


Explain what is the hybrid framework?

578


Hi, I wanted to go with TestingDomain-Automation. Regarding this I need to take training on any one tool either WinRunner or LoadRunner. Which is better to get job,having future and takes lesstime with easier***. pls mention one tool name. Basically iam manual test engineer on unix- platform.

1520


1.Which functinalities of QTP using in onlinebanking system? 2.in lift which kind of testing you perform? 3.how do you test money is transform from one account to another account in online banking?

1821