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

How to write a left outer join with the where clause in oracle?

1151

How to select all columns of all rows from a table in oracle?

1130

What is oracle latest version?

1173

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1955

How to start an oracle instance?

1103

How to use values from other tables in update statements using oracle?

1156

How to put more than 1000 values into an oracle in clause?

1113

Design database draw er diagram for a certain scenario ?

4654