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 / girija.112

select *
from employees
where rowid = (select max(rowid)
from employees)
or rowid =(select min(rowid)
from employees)

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to view the data files in the current database?

1079


What is open database communication (odbc) in oracle?

987


What is meant by a deadlock situation?

1092


11. Display the client number and name and the client number and name of the person who referred that client.

2321


What is connection pool in oracle?

972


I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

3312


Explain the difference between sap and oracle?

1017


What are the extensions used by oracle reports?

1024


How to define an oracle sub procedure?

1118


Can we commit inside a function in oracle?

942


Explain the use of online redo log files in oracle.

1027


How to list all user accounts in oracle?

1007


How to define a cusotmer as a supplier in ORACLE R12

2212


What privilege is needed for a user to delete rows from tables in another schema?

1048


How to Truncate Table in Oracle

1135