Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to display the third record from the employee
table?
- 4 Answers
- 8294 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
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks
What is a Framework manager?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
What is the importance of having monitor service in cognos?
Please explain the different stages in creating a report in cognos report net?
What is main difference mapplets and mapping?
How create measures and dimensions?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
How security is concerned with Reportnet? Explain its implementing steps.
How to a create header dynamically in a crosstab report in cognos 8.1?
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
what are the names of the reports that you prepared?
What is meant by drill down?
Write various indexes used in cognos?
How create measures and demensions?
