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
What are the different ways to check a date field in a website?
Hi, i am looking job in perfomance testing using Loadrunner can any body help me a project in any domine plz(Usah) chs_29@rediffmail.com
Describe your personal software development process.
what is the testing approach for windows Explorer(Not IE Explorer)
What is difference in between operating system 2000 and os xp?
HI, This question is Investment Banking domain related Question. I was asked in an Interview to tell the 5 test cases for Equity,Bond,Futures and options. Please help.. Pragya
I have an Interview about Guidewire claimcenter,so could you provide any info regd it?.I would really appreciate any kind of help- email at hvshah2001@gmail.com
What is a maturity level?
If we have no srs, brs but we have test cases does you execute the test cases blindly or do you follow any other process?
What is baseline testing?
A form has four mandatory fields to be entered before you submit. How many numbers of test cases are required to verify this? And what are they?
What is grey box testing?
what is test case management?explain in brief.
Explain Testing process in your organization?
You may be overqualified for this position we have to offer