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


Please Help Members By Posting Answers For Below Questions

What is the difference between a cascading report and drill through the report?

926


What are the types of security?

768


What is the information present in the cognos configuration file?

736


How to create model and how to test model?

792


Why cognos decision stream is used?

862


How to deploy from one server to another server?

2208


What do you understand by the term 'model durability'?

776


What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?

715


4. How many dimensions did you use in your reports?

1675


what is the difference between filter and condition?

823


Can you define a catalog and types of catalogs in cognos?

773


How do you call a store procedure within a transformation?

767


hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1716


What are cognos connection initial page components?

823


What is the difference between ‘macro’ and ‘prompt?

745