Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to display the third record from the employee
table?
- 6 Answers
- 10413 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / i.anil
select a.*,rownum from
(select b.*,rownum rk from
(select * from emp )b)a where rk=3;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
How to generate cubes in cognos?
WHAT ARE THE DISTNICT VARIABLES?
What are all the components of Report Studio?
What are the components of report net?
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)?
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
What are the ways to import data into catalog?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
1. Explain your project.
What is Online View?
--------------Diff b/w ODS and OLAP?
What r the names of the reports that you prepared?
How do you call a store procedure within a transformation?
what is the difference between querystudio in reportnet and cognos8
