write a query to display to 10 max record from the employee
table?
Answer Posted / madhoo
You are question is not clear.....you need decide based on
which column you want first 10 records.....
if you work on Salary column this is the query .......
select distinct sal from emp a
where (select count(*) from emp b where a.sal<b.sal)<=10
order by sal desc
/
Any queries on Sql please feel free to ask me i am very
interest in it......
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Mention the difference between ‘macros’ and ‘prompt’?
How security is concerned with Reportnet? Explain its implementing steps.
What are the different uses of a repository manager?
how can I test reports in cagnos?
How create measures and demensions?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
Can you define cube?
What is Metrics designer?
Can we test the report other than manual testing?
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
Explain what is the main advantage of impromptu over cognos reportnet?
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com
How is possible this scenario using in type-in prompt.?
Can you define cognos powerplay?