Write a query to find second highest salary of an employee.
Answer Posted / kapil deep
SELECT * FROM (SELECT * FROM emp_t WHERE ROWNUM < 3 ORDER
BY salary) WHERE ROWNUM < 2
above query work fine for oracle.
Taking 3 as N give u 3-1=2 i.e 2nd highest
4-1=3 gives u 3rd highest
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
pls tell me any open source test case managment tool ? its urgent.also tell me any autmation testing tool also for functional testing?
Define sdlc in testing.
notice the distinction between data driven testing and retesting?
Elaborate the fields in bug report in automated testing
What are the important operations in database testing?
Tell me what is regression testing?
Explain me what the webdriver supported mobile testing drivers do you know?
Do you know how to check if a button is enabled on the page?
4. How we implement Winrunner,in our project?
What is test automation?
Tell us how to login into any site if it's showing any authentication pop-up for username and password?
Program/pseudo code on FIFO? Input a string and make sure that output is in FIFO manner. Eg, Enter 'John Dave' as input and output should be 'John Dave' not 'Dave John'. (inbuilt functions like push, pop were given)
I am surekha new commer for this site? I have some doubt's pls clarify it..... I finished my B.tech and S/w Testing Course Now iam searching for a job in Testing, I did not have any experience in real time projects. Any body can send me the sample Testcases,Srs,Matrix for Banking,ERP Projects etc.Here is my email id surekhai@yahoo.com
hi i would like to know is there any training institue for Calabash,robotium and ui automator in hyderabad...urgent
What is self-referencing constraint in mainframe development?