how to retrieve 1st and last row of table without using
group functions??
- 6 Answers
- 7647 Views
- I also Faced
- E-Mail Answers
Answer Posted / sudipta santra
For the 1st row:
select * from emp where rownum<2 order by empno;
For the last row:
select * from emp where rownum<2 order by empno desc;
| Is This Answer Correct ? | 14 Yes | 5 No |
Post New Answer View All Answers
What is instant client oracle?
What is an oracle?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What is a table index in oracle?
What is meant by joins? List out the types of joins.
What is oracle used for?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What is the difference between post-database commit and post-form commit?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
How to use subqueries with the in operator using oracle?
What is the Tune Query
How to retrieve values from data fields in record variables?
How to use like conditions in oracle?
How to initialize variables with default values?
Is oracle an open source?
