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
Explain what are synonyms used for?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
What are the differences between lov and list item?
What is translate in oracle?
What is the simplest tool to run commands on oracle servers?
How many types of table in Oracle?
How to get execution path reports on query statements?
What is query image?
Explain enable novalidate constraint.
How to create a new table in oracle?
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.
What are the roles of dba?
How to export data with a field delimiter?
How to insert a new row into a table in oracle?
Explain overloading. Can functions be overloaded?