How to get Top 10 Salaries from a Table
Answer Posted / bharath
select sal from(select ename,sal rownum from emp orderby sal
desc group by sal,rownum)where topsal='&nth';
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
When reorg is used?
What is the max length of sqlca?
What is deadlock in db2?
What is a Foreign Key?
What language is db2 written in?
What is runstats db2?
Why do we need reorg in db2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is page size in db2?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
How is deadlock resolved?
What is sqlca?
How many databases can be created inside an instance in db2 ?
Why select is not preferred in embedded sql programs?
How do I import data from excel to db2?