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

who introduced sql?

947

Is ms sql traffic encrypted?

867

Which data dictionary views have the information on the triggers that are available in the database?

1179

Can we use rowid as primary key?

941

how to increment dates by 1 in mysql? : Sql dba

924

Which one is better subquery or joins?

1007

What is character functions?

1013

How do I write a sql query in pgadmin 4?

923

what are the nonstandard string types? : Sql dba

1078

What is raw datatype in sql?

976

What is on delete restrict?

936

What is an intersect?

1041

Explain the the update statement in sql?

986

how to write date and time literals? : Sql dba

912

Where is sql database stored?

918