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

How do I view an execution plan in sql?

924

List different type of expressions with the example.

896

Is it possible to sort a column using a column alias?

994

What is sql select statement?

971

Does sql support programming?

1008

Explain the commit statement.

1103

What is sql and db2?

944

What is difference between left and right outer join?

933

Describe types of sql statements?

994

Is sql a scripting language?

924

What is the difference between view and stored procedure?

913

What are the commands used in sql?

1017

How do we use distinct statement? What is its use?

977

what is a composite key ? : Sql dba

995

How do you delete data from a table?

976