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

Answer Posted / reddy

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Will you be able to store pictures in the database?explain.

994

Explain the use of indexes option in exp command.

1149

How do you store pictures in a database?

1008

State and explain about oracle instance?

1000

How do we get field details of a table?

980

Can I create users through internet explorer in oracle 10g?

1084

How to run queries on external tables?

1050

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2209

What are the different types of database objects?

1063

How to Truncate Table in Oracle

1158

What is recovery manager(rman) backup in Oracle?

1185

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1934

What is procedure overloading in oracle?

1061

How to check the server version in oracle?

1094

What is the relation of a user account and a schema in oracle?

1080