Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve first and last records from a table?
- 7 Answers
- 12261 Views
- DELL, QSmart, I also Faced
- E-Mail Answers
Answer Posted / avnish srivastava-test engg fc
select* from employees where rowid=(select min(rowid) from
employees)
union
select* from employees where rowid=(select max(rowid) from
employees)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is oracle a programming language?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What happens to the current transaction if the session is killed?
How can we find out the current date and time in oracle?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What is the scope of a local variable?
What are the restrictions in a oracle read only transaction?
What is translate in oracle?
How to define an anonymous procedure without variables?
How to set a transaction to be read only in oracle?
How to import one table back from a dump file?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
In what script is snap$ created? In what script is the scott/tiger schema created?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
Explain about functional dependency and its relation with table design?
