SELECT * FROM EMP WHERE ROWID = (SELECT MIN(ROWID) FROM EMP) UNION SELE

how to retrieve 1st and last row of table without using
group functions??

Question Posted / ajitnayak

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

Please Help Members By Posting Answers For Below Questions

What do you understand by a database object? Can you list a few of them?

1014

How to manage transaction isolation level?

998

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1649

What is a trigger and what are its types in oracle?

1062

How to get execution statistics reports on query statements?

1080

What is the order of defining local variables and sub procedures/functions?

1053

How to drop a stored procedure in oracle?

1049

How to use subqueries in the from clause in oracle?

1103

How can Oracle users be audited?

1104

Explain an exception and its types?

1068

what is the scripts in data base?

2147

How to write a query with a right outer join in oracle?

1156

How to change system global area (sga) in oracle?

1004

What is a trigger oracle?

1082

How do I spool to a csv formatted file using sqlplus?

1022