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
19263 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

How can triggers be used for the table auditing?

1049

What is data type in sql?

941

explain normalization concept? : Sql dba

1031

what are the t string functions available in tsql? : Transact sql

992

What are the advantages of sql? Explain

1083

Is sql microsoft?

1032

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1092

Which operator is used in query for pattern matching?

1072

Why are sql stored procedures used?

1043

Mention what pl/sql package consists of?

980

What is the difference between mdf and ndf files?

1096

How do I upgrade sql?

987

What is a data manipulation language?

1007

what is sql server agent? : Sql dba

1082

How do I start sql from command line?

1001