Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to display the third record from the employee
table?
- 4 Answers
- 8309 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / g.arangarasu
No friends,
rownum is one of the column name of table like
emp_no,emp_name etc. if u have not rownum column in ur
table,how to solve it.
we can retrieve this record through physical location that
is using rowid not rownum.
select min(rowid) from emp not in(select min(rowid) from
emp not in(select min(rowid) from emp));
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Mention the difference between ‘macros’ and ‘prompt’?
Can you define set to be cardinality?
What is Online View?
what is requery in cognos?
Explain difference between powerplay transformer and power play reports?
What is the deployment requirements used in cognos?
When we save a report in report studio with what extn it save?
write a query to display the departments with no employee?
What are query items?
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
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 difference between page break and section report? What is main advantage datawarehousing over oracle?
How is cognos model organization works?
What is meant by drill down?
What is the size of the cube?
