write a query to display the third record from the employee
table?
Answer Posted / krishna
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 ? | 9 Yes | 0 No |
Post New Answer View All Answers
How to test a cube?
how can you get the errors in job? when loops are araised we get error?
Can you define drill down and drill up?
can you tell me what are the dimension tables are used in project
Write some methods to apply securities in framework manager model?
How the Bursting happens in same report and how to Print the bursting Report?
What are all the types of gateway used in Cognos?
What do you understand by the term 'model durability'?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
What is a Pivot?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
Can you define a datastore in cognos?
What is a Datastore in Cognos?
Define the cognos reporting tool?
What is the complex report you faced in real time?