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
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)?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
What is main advantage datawarehousing over oracle?
--------------Diff b/w ODS and OLAP?
What do you understand by user class in cognos?
Explain is there any comparison available for cognos reportnet vs crystal reports?
hi friends pls forward impropmtu interview question
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 is cognos model organization works?
is cognos 7 is better than cognos 8
What is the use of powerplay web viewer in cognos?
how you provide security to reports? How you provide security to packages ?
What is Online View?