Write a query to find second highest salary of an employee.
- 72 Answers
- 109266 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / aj
select * from emp A where 1=(select count(*) from emp B
where A.SALARY < B.SALARY)
| Is This Answer Correct ? | 12 Yes | 9 No |
Post New Answer View All Answers
I am new to Test Complete ,can any one suggest me the steps to create/Record and replay a test in Test complete 6....
Can anyone tell me the correct answer of below question....it is about Bugzilla tool. When bug will find out at the time of executio where it will save or what is the location of bug??
What all things can you automate?
What is vendor tool and give examples?
Can you list some other automation testing tools that you are familiar with?
What u mean by infrgistics control (What is infrgistics Controls)?
How do we Test the C++ and Unix Application Using Automated Tool.
Give some examples for defect management tools?
8. How we test web based application
Can any one give me the script for drag and drop or setselection functions ?like in a not pad i want to select 5 lines
what is aom and how to add object repository? i am very new to QTP please help me
What are the primary features of good automation tool ?
Tell me an example of the languages supported by webdriver?
In Selenium how a test suit is run and report is generated.
What is self-referencing constraint in mainframe development?
