write the sql query to display 5th and 10th row in a table?
Answer Posted / harish
select * from emp where rownum<=&n;
if u give 5 insted of 'n' we get 5th record...
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Can you define folder?
can you tell me what are the dimension tables are used in project
1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE
What are the considerations regarding performance kept in mind while setting up cognos?
How security is concerned with Reportnet? Explain its implementing steps.
How to apply securities for reports in cognos connection?
What is set to be cardinality?
Can you explain new content durability?
Can you define fan trap?
Can you define set to be cardinality?
What is called materialized view?
How to Reset Pagenumbers in one report.
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
5. Which type of report you build more, list, crosstab or chart and why?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?