How to retrieve first and last records from a table?
Answer Posted / reddy
select*from emp where rowid in (select min(rowid),max(rowid) from emp);
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a trigger oracle?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
what are the advantages of running a database in archive log mode?
How do we create privileges in oracle?
what is reindexing?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
What is ADDM Advisor in Oracle?
What is the max number of columns in an oracle table?
How to view existing locks on the database?
Write a syntax for update query in oracle?
What is redo log?
What is a procedure in oracle?
can u plz provide me oca sql dumps please i need them
What happens if recursive calls get out of control?
What is rowid and rownum in oracle?