write a query to display the third record from the employee
table?
- 4 Answers
- 6854 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
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
explain how to create powerplay reports?
What is the advantage of using shortcuts?
How do you improve the performance of the Cognos Analytics report
What are all the types of gateway used in Cognos?
can you tell me what are the dimension tables are used in project
How do we convert from Numeric to be Words?
Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance
Why cognos scenario is used?
What are the types of studio?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
Can you explain cognos planning?
is there any difference between operational database and data base?if yes what r they?
What is an olap designer?
