Write a query to find second highest salary of an employee.
Answer Posted / ashutosh singh
select distinct(a.Sal) from emp a where &n=(select
count(distinct(b.Sal)) from emp b where b.Sal<a.Sal)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Tell me what kind of tests should not be automated?
I am new to Test Complete ,can any one suggest me the steps to create/Record and replay a test in Test complete 6....
what is the advantage and dis-advantages of using framework ?
What kind of tests would you automate?
Write a short compiled module which selects random numbers. and what function is used to call your customized compiled module?
Name some of the commonly used automation testing tools that are used for functional automation.
What should you do after finding a bug?
List of Test Management Tools??Is Quality Center Test Management tools
What is junit? And what is junit annotation?
hi i would like to know is there any training institue for Calabash,robotium and ui automator in hyderabad...urgent
What is extreme programming and what has it got to do with testing?
Define sdlc in testing.
On Test Complete I recorded some keyword test. while I'm running the batch test, if one test case failed, then how test complete skip the failed test case and again continue to run the test case? please provide some way to resolve this issue.
What is a ‘test plan’? What is a ‘test case’?
how to know whether the user information or any other information which is entered in to the web is storing in secured place or non secured place?