write a query to display the third record from the employee
table?
Answer Posted / m m naidu
To display the 3rd record of emp table we can write query as
select * from emp where rownum<4 minus select * from emp
where rownum<3;
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Define cognos report net?
1. Explain your project.
Can you define cube?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
Diff b/w Crossproduct and Outerjoin?
What is the model filter?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
Can you explain new content durability?
Define dimensions?
Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..
What are the steps to import the two data sources in framework manager?
-----------------What is Direct and Conventional loading?
4. How many dimensions did you use in your reports?
What are query items?
Write various indexes used in cognos?