SELECT * FROM (SELECT * FROM EMP ORDER BY EMP

how to retrieve 1st and last row of table without using
group functions??

Question Posted / prabhudatta

Answer Posted / prabhudatta

SELECT * FROM (SELECT * FROM EMP ORDER BY EMP_NO) WHERE
ROWNUM=1

UNION

SELECT * FROM (SELECT * FROM EMP ORDER BY EMP_NO DESC)
WHERE ROWNUM=1;

Is This Answer Correct ?

14 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What do you know about normalization? Explain in detail?

1002

What is oracle sid?

1005

what is the difference between data migration and production migration.

2398

Explain an exception?

1064

What are joins, explain all types of joins?

2361

What are the types of partitions in oracle?

1078

How do I call oracle stored procedures that take no parameters?

1203

What is bulk load in oracle?

1126

How a tablespace is related to data files?

1165

What operating systems are supported by oracle database 10g xe?

1086

What are the roles of dba?

1136

What is an Oracle Instance?

1163

Why should I use oracle database?

1046

What is a table in oracle?

1022

Which is better Oracle or MS SQL? Why?

6484