Select * from table_name where rowid =(select min(rowid) from tanle

Hi Everyone,
How to get fist and last record from a table in oracle?

Thanks in advance

Question Posted / ramesh

13 Answers
19860 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / ramesh

Select * from table_name where rowid =(select min(rowid)
from tanle_name)
union
select * from table_name where rowid = (select max(rowid0
from table_name);

Is This Answer Correct ?

5 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Are stored procedures faster than queries?

990

How do you get column names only for a table (sql server)?

1217

What is the best partition size for windows 10?

1049

What is sql profiler in oracle?

1160

Where can I learn sql for free?

1049

What is a schema? How is it useful in sql servers?

1174

Is record in oracle pl sql?

1017

Can we create a trigger on view?

946

Explain what is sql?

1180

Is not null in sql?

1045

What is the use of sql trace?

1003

Show the two pl/sql cursor exceptions.

1260

what is the difference between truncate and delete statement? : Transact sql

1121

How to return an array from java to pl/sql?

1181

What is cross join example?

1066