SELECT * FROM (SELECT emp.*, ROWNUM rn FROM emp) WHERE rn =

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

Question Posted / nathan

Answer Posted / nathan

SELECT *
FROM (SELECT emp.*, ROWNUM rn
FROM emp)
WHERE rn = 1 OR rn = (SELECT COUNT (*)
FROM emp);

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what are the default admin accounts in Oracle 10g ?

917

What is Reduced List of Values?

2102

Give the various rollback segment states.

999

How to grant create session privilege to a user in oracle?

946

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2772

Query to retrieve record for a many to many relationship ?

2458

What is an oracle table?

931

What is the difference between postgresql and oracle?

978

How to add another datafile to a tablespace?

992

What is a cursor and what are the steps need to be taken?

1116

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2067

Explain the dml?

919

Is oracle a programming language?

936

What are the varoius components of physical database structure of oracle database?

945

How to convert characters to times in oracle?

954