select * from table_name where rownum=1 union select * from table

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

Thanks in advance

Question Posted / rajesh venati

Answer Posted / rajesh venati

select * from table_name where rownum=1
union
select * from table_name where rowid=(select max(rowid) from
table_name);

Is This Answer Correct ?

27 Yes

5 No

Please Help Members By Posting Answers For Below Questions

discuss about myisam key cache. : Sql dba

976

What is the benefit of foreign key?

962

What are data types in pl sql?

1078

what does it mean to have quoted_identifier on? : Sql dba

1101

Should I use mbr or gpt?

950

what is the difference between nested subquery and correlated subquery?

988

What is the difference between partition and index?

926

How many indexes can be created on a table in sql?

990

What is data types in sql?

951

What is delimiter sql?

924

What are the advantages of indexing?

929

what is cross join? : Sql dba

941

What do you understand by pl/sql packages?

1020

Why having clause is used in sql?

931

Explain the difference between rename and alias?

966