Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to display the third record from the employee
table?
- 4 Answers
- 8185 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
What do you understand by the term 'dynamic cube'?
What is meant by alternate drill down with ex?
how you create security to reports?
what are slowly changing dimensions? Why we are used scd?
Can you define framework manager?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
What do you understand by user class in cognos?
What is meant by junk dimension?
What is model filter?
Define query studio?
which type of project we r going to snowflake schema
Can you define report item?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
what is power prompt in cognos ep7series?what is the use of this?
