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

Answer Posted / kumar

select * from emp where rownum<4 minus select * from emp
where rownum<3;

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can you tell me what are the dimension tables are used in project

1895


What is difference between page break and section report?

696


Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

1650


what are the special features in cognos reportnet?

627


Cleared COG-112 with 100% score today. What next certification should i go for?

1431






-----------------What is Direct and Conventional loading?

1659


How to a create header dynamically in a crosstab report in cognos 8.1?

1999


WHAT ARE THE DISTNICT VARIABLES?

1761


2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.

1730


Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice

2149


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?

1626


5. Which type of report you build more, list, crosstab or chart and why?

1603


What is difference between informatica power mart and power center?

574


what is the procedure for scheduling conditional rendering?

2020


what are the dimensions that you have in your current project?list them?

1608