write a query to display the third record from the employee
table?
Answer Posted / vsandhyana
select top 1 * from (select top 3 * from employee order by
employeeid desc) emp
Thanks
Vsandhyana
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we test the report other than manual testing?
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
faq's on cognos
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 ?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
What you mean by drill across?
What is the difference between a cascading report and drill through report?
What are cognos connection initial page components?
What is the importance of having monitor service in cognos?
can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com
What is meant by Reportstudio shortcut?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
What is difference between primary key and unique key constraints?
how to perform back drill through in cognos 8 what is the use of it