SELECT * FROM EMP WHERE ROWID IN(SELECT MIN(ROWID) FROM EMP) UNION ALL SE

How to retrieve first and last records from a table?

Question Posted / naveen

Answer Posted / naveen

SELECT * FROM EMP WHERE ROWID IN(SELECT MIN(ROWID) FROM EMP)
UNION ALL
SELECT * FROM EMP WHERE ROWID IN(SELECT MAX(ROWID) FROM EMP);

Is This Answer Correct ?

22 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the roles of dba?

1136

Point the difference between translate and replace?

1148

How to do clean up if create database failed?

1067

What are advantages of dateset in datastage?

2304

How do I escape a reserved word in oracle?

1253

What are the different types of database objects?

1114

Explain view?

1085

What is bind variable in oracle 11g?

1093

How to retrieve values from data fields in record variables?

1169

How to call a stored function with parameters?

1091

Explain do view contain data?

1047

What is the use of oracle?

1075

What is a snapshot log?

1046

What is an oracle?

1063

How to create a new tablespace in oracle?

1030