Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Thanks in advance

Answer Posted / rajesh venati

this will also work

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

Is This Answer Correct ?    23 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to create the following trigger: before or after update trigger for each row?

1287


How do I run pl sql in sql developer?

1120


How do I remove sql developer from windows 10?

1111


Is sql a oracle?

981


Can we insert delete data in view?

951


Explain what is a field in a database and record in a database?

1097


Can we use insert statement in function?

1003


Explain two easy sql optimizations.

1013


what is isam? : Sql dba

1009


How to take user input in pl sql?

1163


Can we join tables without foreign key?

962


How do I install sql?

1002


How to install oracle sql developer?

1046


What is the use of prepared statement?

1025


How do you delete a table?

1075