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

how to handle exceptions in post production

1358

Can we store pictures in the database and if so, how it can be done?

981

What are the extensions used by oracle reports?

994

Explain index?

1195

How to store pictures on to the database?

923

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5329

What is meant by recursive hints in oracle?

1024

What is an oracle cursor variable?

1002

What exactly do quotation marks around the table name do?

915

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1874

How to assign data of the deleted row to variables?

1012

How many categories of data types?

934

Explain view?

976

How do you store pictures in a database?

946

what is reindexing?

1608