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

What are the common oracle dba tasks?

1200

How to define a data source name (dsn) in odbc manager?

1078

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2089

How to define an external table with a text file?

1122

What is the difference between substr and instr?

1088

How to execute a stored program unit?

1126

How do I limit the number of rows returned by an oracle query after ordering?

1221

What are the different types of record groups in oracle? Explain each of them

1069

What is a cursor variable?

1213

Explain coalesce function?

1247

what is dynamic SGA and static SGA

4482

How to start an oracle instance?

1071

How to create a new user account in oracle?

1063

What is a trigger and what are its types?

1320

What is the usage of analyze command in oracle?

1139