Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve first and last records from a table?
- 7 Answers
- 12063 Views
- DELL, QSmart, I also Faced
- E-Mail Answers
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
What is data file?
What is the meaning of recursive hints in oracle?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
What is a nvl function? How can it be used?
What are the built-in functions used for sending Parameters to forms ?
List the various oracle database objects?
What are the different types of trigger and explain its various uses and functions?
How to work with data objects interactively?
What is the difference between 10g OEM and 11g OEM?
what is the difference between substr and instr function in oracle?
Point the difference between translate and replace?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
Can select statements be used on views in oracle?
Explain the use of owner option in exp command.
