How to retrieve first and last records from a table?
- 7 Answers
- 9897 Views
- DELL, QSmart, I also Faced
- E-Mail Answers
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
How to compare dates in oracle sql?
What is the use of file param in imp command?
How to define a procedure inside another procedure?
How can we find out the current date and time in oracle?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
How many types of auditing in Oracle?
How do I learn what codesets are available in oracle?
What is a named program unit?
How to use "in" parameter properly?
What is the database name in oracle?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What is the difference between a user and a schema in oracle?
What is meant by joins?
What is a directory object?
What are the differences between interval year to month and interval day to second?
