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

7 Answers
12054 Views
DELL, QSmart, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1118

What is connection pooling in oracle?

978

Explain oracle instance.

1187

What are the differences between primary key and unique key?

1014

Explain the blob datatype?

1080

How to use regular expression in pattern match conditions in oracle?

1046

Explain temporal data types in oracle

1098

How to start a new transaction in oracle?

1090

How can windows applications connect to oracle servers?

1064

How to export data to a csv file?

1313

How to pass parameters to procedures in oracle?

1047

How to Truncate Table in Oracle

1165

What is materialized view in Oracle?

1078

What is a directory object?

1101

What is hash cluster in oracle?

1180