Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrieve 1st and last row of table without using
group functions??
- 6 Answers
- 8731 Views
- I also Faced
- E-Mail Answers
Answer Posted / ajitnayak
SELECT *
FROM EMP
WHERE ROWID = (SELECT MIN(ROWID) FROM EMP)
UNION
SELECT *
FROM EMP
WHERE ROWID = (SELECT MAX(ROWID) FROM EMP)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you mean by redo log file mirroring?
How to check your oracle database 10g xe installation?
what is the difference between substr and instr function in oracle?
How to set up autotrace for a user account?
What are the different editions of oracle?
What is rowid and rownum in oracle?
What are internal user account in oracle?
How to create a new table in oracle?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
what is IDE,DMV in sql server?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
What is oracle open database communication (odbc)?
What is the exact use of Collections?
How to create a stored function in oracle?
What is the difference between truncate & delete command?
