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

Why do we use joins in sql?

970

what is schema? : Sql dba

1048

How do I edit a stored procedure?

992

Explain the uses of control file.

1050

What is difference between joins and union?

1124

What is trigger types of trigger?

1069

Describe sql comments?

1039

Explain cursor types?

1026

What is a behavioral trigger?

972

What is nvarchar in sql?

924

What is the advantage of index in sql?

971

what is union, minus and interact commands? : Sql dba

1185

explain mysql aggregate functions. : Sql dba

990

What is not null in sql?

1055

List and explain the different types of join clauses supported in ansi-standard sql?

1356