select * from table_name where rowid in ((select min(rowid) from table

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

Thanks in advance

Question Posted / chandana

Answer Posted / chandana

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

Is This Answer Correct ?

8 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is the command used to fetch first 5 characters of the string? : Sql dba

1687

what is the difference between blob and text? : Sql dba

1065

How do I trace sql profiler?

1046

What is sql dialect?

1182

what are the different type of sql's statements ? : Sql dba

982

What is auto increment in sql?

1180

How would you convert date into julian date format?

1046

What is a composite primary key?

1144

What is user defined functions?

1031

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

1059

what is a record in a database ? : Sql dba

1105

How do you create a db file?

1071

What is attribute indicator in pl sql?

1070

What is coalesce sql?

1058

Show the cursor attributes of pl/sql.

1106