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

If a cursor is open, how can we find in a pl/sql block?

1148

What are tables in sql?

1041

How to get unique records from a table?

941

What is a design view?

915

Why is the cursor important?

1022

What are the constraints available in sql?

1027

What is the difference between the implicit and explicit cursors?

1033

What is rank () in sql?

923

Does access use sql?

1018

what is a stored procedure? : Sql dba

1108

how do you know the version of your mysql server? : Sql dba

986

What is the difference between a primary key and a clustered index?

968

How many aggregate functions are available there in sql?

965

How is use pl and sql?

1048

How many types of relationship are there?

1016