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
How to deploy from one server to another server?
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
Explain the characteristics of cognos?
-----------Diff b/w OLAP and RDBMS?
What is the difference between low affinity and high affinity connections?
what are the errors faced while bursting the reports and how to solve those errors?
hi friends pls forward impropmtu interview question
Why is auto-regression used in forecasting used on cognos platform?
What is Bitmap Index?
Mention the difference between ‘macros’ and ‘prompt’?
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
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 ?
How to publish a package by running Java Script?
7. What is performance tuning?
Define the cognos reporting tool?