How to retrieve first and last records from a table?
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
What is the scope of a local variable?
What is the order of defining local variables and sub procedures/functions?
What is instant client oracle?
Explain the use of analyse option in exp command.
How to view existing locks on the database?
Explain integrity constraints?
What is system tablespace?
How to convert numbers to characters in oracle?
What do you mean by group by clause?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
How do I recompile a procedure in oracle?
How does the on-delete-cascade statement work?
What is a snapshot in oracle database?
How to shutdown your 10g xe server from command line?
What is ASM (Automatic Storage Management) in Oracle?