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...

How to retrieve first and last records from a table?

Answer Posted / reddy

select*from emp where rowid in (select min(rowid),max(rowid) from emp);

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do database buffers contain?

1005


What are the common oracle dba tasks?

1123


What is oracle analytical function?

1111


How to resolve the ORA-39133 error in Oracle?

1093


What are the database administrators utilities available?

1009


What is different types of joins?

1007


Explain oracle’s server parameter file.

974


1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

2064


How to call a sub procedure?

1075


Why oracle is used?

1034


Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1850


What is a connect identifier?

1025


How many types of auditing in Oracle?

1020


How to execute the package in oracle?

1070


What is the disadvantage of User defind function?

2270