SELECT * FROM EMP WHERE ROWID = (SELECT MIN(ROWID) FROM EMP) UNION SELE

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

Question Posted / ajitnayak

Answer Posted / ajitnayak

SELECT *
FROM EMP
WHERE ROWID = (SELECT MIN(ROWID) FROM EMP)
UNION
SELECT *
FROM EMP
WHERE ROWID = (SELECT MAX(ROWID) FROM EMP)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Differentiate between function and procedure in oracle.

555

How to count groups returned with the group by clause in oracle?

564

Explain the use of show option in imp command.

631

Explain the use of tables option in exp command.

585

How to connect ms access to oracle servers?

540

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

4659

What is the difference between hot backup and cold backup in oracle?

520

What is clustered table in Oracle?

635

How to sort the query output in oracle?

599

What is tns service name?

607

Can we commit inside a function in oracle?

548

What is the minimum client footprint required to connect c# to an oracle database?

560

What is a trigger and what are its types in oracle?

530

What is sharded cluster?

514

how to handle exceptions in post production

938