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
What is data - driven automation?
HOW CAN WINRUNNER AND TEST DIRECTOR CONNECTED TO THE DATABASE AND WHAT R THE OPTIONS?
why should we choose VSTET(Visual Studio Team Edition for Testers) and not QTP?pleas give me the reasons for "WHY" we have web and client server app, supports power builder and on windows OS so this is the background of tech and envir things we have and now VSTET is good to use or not? if "NO" then tell me why
On what factors can you map the success of automation testing?
Generic function for selecting a Radio Button in a Dialog
What are the important operations in database testing?
Do you know what is the purpose of deselectall() method?
Tell me what is intellij?
What generally is the structure of a framework?
What is self-referencing constraint in mainframe development?
What u mean by infrgistics control (What is infrgistics Controls)?
Explain how to perform load-testing?
what we have done after display the result in openSTA result pane.in the sense that how we send the report,what we send in report,how to know that where is error.quickly tell me the answer...please
Give some examples of priority – severity defect levels.
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}?