write a query to display the third record from the employee
table?
Answer Posted / srinu
select * from (select rownum r,emp.* from emp) where r=3;
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Define datastores in cognos?
WHAT ARE THE DISTNICT VARIABLES?
Can you define materialized view?
What is cognos connection?
Why are meta service important then other services?
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
What DB View and Bus View?
What is meant by Reportstudio shortcut?
How create measures and dimensions?
What are the other methods working as deployment functionality?
Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..
Can you define pivot?