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
How to view the data files in the current database?
What is open database communication (odbc) in oracle?
What is meant by a deadlock situation?
11. Display the client number and name and the client number and name of the person who referred that client.
What is connection pool in oracle?
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.
Explain the difference between sap and oracle?
What are the extensions used by oracle reports?
How to define an oracle sub procedure?
Can we commit inside a function in oracle?
Explain the use of online redo log files in oracle.
How to list all user accounts in oracle?
How to define a cusotmer as a supplier in ORACLE R12
What privilege is needed for a user to delete rows from tables in another schema?
How to Truncate Table in Oracle