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

Answer Posted / krishna

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 ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you define slice?

628


Can you explain new content durability?

576


Can you define framework manager?

628


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

658


What is zero-foot print?

598






What are all the types of report?

571


can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

1875


can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com

1717


--------------Explain Table of contents?

1561


hi friends pls forward impropmtu interview question

1689


What is main difference mapplets and mapping?

572


how to connect datamarts

2378


What are the considerations regarding performance kept in mind while setting up cognos?

566


What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?

1620


What is cognos reporting tool?

618