select a.*,rownum from (select b.*,rownum rk from (select * from emp )b)

write a query to display the third record from the employee
table?

Question Posted / i.anil

Answer Posted / i.anil

select a.*,rownum from
(select b.*,rownum rk from
(select * from emp )b)a where rk=3;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is called Cognos powerplay?

1048

whats the difference between previous version of cognos and cognos 8 BI?

5467

Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.

1807

Explain is there any comparison available for cognos reportnet vs crystal reports?

926

how to create cubes in transformer ?

1032

What is a Datastore in Cognos?

1251

What is catalog and types of catalogs in cagonos and which is better?

956

what is hints in cognos and where we use it.

2421

Define datastores in cognos?

912

What is Additive function?

1994

What is difference between page break and section report?

1177

Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days

3582

What is the use of report studio?

995

What is called materialized view?

1019

What is difference between content store and content manager?

938