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

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1886


How a tablespace is related to data files?

1072


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.

2032


How to set a transaction to be read only in oracle?

1045


What are the differences between char and varchar2 in oracle?

1093


How to define an anonymous procedure without variables?

1040


How to create a single index for multiple columns?

989


What are the oracle built-in data types?

1024


What are the uses of Database Trigger ?

1644


What are the general rules on data consistency?

964


What is columnar storage what is the advantage?

1001


Explain the use of indexes option in imp command.

1108


What is the data type of dual table?

930


What is meant by joins? List out the types of joins.

972


How does oracle handle read consistency?

1058