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 tns file?

1040

Explain the use of rows option in exp command.

1147

What are oracle functions?

1087

Is oracle a language?

987

How to drop an existing view in oracle?

992

How do I connect to oracle?

1080

How to loop through a cursor variable?

1126

What is the maximum number of triggers that can be applied to a single table?

1067

Who developed oracle & when?

1057

What privilege is needed for a user to create views in oracle?

1091

Can we insert data in view oracle?

1111

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2190

What are the components of logical database structure in oracle database?

1134

Where is the export dump file located?

1221

Explain the characteristics of oracle dba?

1175