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 is a static data dictionary in oracle?

1023

Explain oracle data types with examples?

965

What is the minimum client footprint required to connect c# to an oracle database?

1016

what happened to the global index when I truncate the data in one of the partition?

1959

How to recover a dropped table in oracle?

983

How to export data to a csv file?

1198

What happens if you set the sga too low in oracle?

1051

How to use "if" statements on multiple conditions?

1108

What is the data pump export utility?

1019

What is the difference between 10g OEM and 11g OEM?

916

What happens if recursive calls get out of control?

997

What is the use of oracle?

980

Why is oracle used?

878

What is a database schema in oracle?

1052

How to retrieve data from an explicit cursor?

1006