To display the 3rd record of emp table we can write query as select * from

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

Question Posted / m m naidu

6 Answers
8245 Views
HCL, I also Faced
E-Mail Answers

Answer Posted / m m naidu

To display the 3rd record of emp table we can write query as
select * from emp where rownum<4 minus select * from emp
where rownum<3;

Is This Answer Correct ?

6 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What do you mean by query studio?

500

Hi All, I have 1.6 years of experience in cognos in India. I always wanted to do a MS program to earn some money in US. But I think I am little late in taking the decision. As If I have to write my GRE it will be August or September of 2012 and will have to apply for fall 2013 as fall 2012 admissions are almost done now. So my concern is how will be my career do if my MS is at this stage,. i,.e. 3 years experience in Cognos and 2 years MS program in and again looking for job in U.S. Have I been too late in taking the call? I heard that MIS (Managing Information Systems) is having very good placements now. So guys, please advice me in taking the decision to have a good career and also in terms of earning money as I have few financial problems to solve (which I am hoping to solve when I get job in US after completion of my MS program). Thanks a lot friends. I really appreciate and thank one and all for their valuable comments in this site.

4812

What is looping and how to avoid it in framework manager?

650

Can you explain new content durability?

566

how can I test reports in cagnos?

624

is there any difference between operational database and data base?if yes what r they?

1582

What is the complex report you faced in real time?

1716

What do you mean by drill through report?

570

How we check the errors before running the report?

535

how can you get the errors in job? when loops are araised we get error?

1642

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

1682

Please explain the different stages in creating a report in cognos report net?

557

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.