Answer Posted / shankar
Hi...
here is the query to find out the n'th maximum salary
note: 1.'emp' is Table name & 'sal' is column name.
2.'distinct' is used for finding the unique value
3.'count' is for counting the values.
Query:
------
SELECT * from emp
where sal = (SELECT distinct(sal) from emp x
where &n = (SELECT count(distinct(sal)) from
emp where sal >= x.sal));
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
pl. give me the list of top jobs website to register i have 2Yrs. Experience in manual testing
You must test a trouble report where the problem cannot be reproduced. You tried using various test data files and mutations from the data files the customer sent along with the trouble report. The software does not fail the way it did at the customer's site.
how recovery manager works in winrunner
How can I done a Web Testing? Which steps are include in it?
can anyone tell anyone is providing training for CSTE exam in bangalore? and can u send some links related to this?
How do you determine user soad for a perf test of a Web application?
What are testing techniques? What is difference between general and specific?
How do you scope, organize, and execute a test project?
i) functional test cases can we consider for regression test ? or we have to write separet test cases for regression test ? ii) How to write the system test case and what are the technique shall we have to follow ?
Please anyone give answers for all below questions and help ? realtimers please and please share your knowledge.lot of questions left unanswered.
What are the factors affecting a manual testing project and what are the ways to overcome it?
1.Tell me negative test cases for notepad 2.Tell me the factors for for writing severity based test cases
What is the difference between load and stress testing?
can u write some high level scenarios on ms outlook express
Do you know anything about Set Top Boxes?