select*from emp where rowid in (select min(rowid),max(rowid) from emp);

How to retrieve first and last records from a table?

Question Posted / reddy

7 Answers
12065 Views
DELL, QSmart, I also Faced
E-Mail Answers

Answer Posted / reddy

select*from emp where rowid in (select min(rowid),max(rowid) from emp);

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How will you identify oracle database software release?

1020

How to generate query output in html format?

1133

How to filter out duplications in the returning rows using oracle?

1020

How to create a table in a specific tablespace?

985

How to define a cusotmer as a supplier in ORACLE R12

2236

Is oracle the best database?

973

Explain oracle instance.

1187

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1965

What are the uses of a database trigger?

1002

Explain index?

1269

How to name query output columns in oracle?

1197

How to put more than 1000 values into an oracle in clause?

1039

What are the varoius components of physical database structure of oracle database?

1011

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2346

What is an oracle cursor variable?

1090