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 is the exact use of Collections?

2106

How to rename an existing table?

1061

How to create a temporary table in oracle?

1214

What is an oracle function?

1094

What are the parameters that we can pass through a stored procedure?

1008

What is bulk load in oracle?

1018

What is the difference between substr and instr?

989

How to delete all rows a table in oracle?

1025

What is system tablespace?

1054

How to connect to a remote server?

1069

How to resolve the ORA-39133 error in Oracle?

1056

What are group functions in oracle?

990

How translate command is different from replace?

1031

Explain the dml?

928

What is set operator oracle?

936