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

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1698

What is the difference between substr & instr functions?

826

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

1785

Who developed oracle & when?

744

How to check the oracle tns settings?

786

What is a synonym? What are its various types?

856

Differentiate between function and procedure in oracle.

770

What is a nvl function?

743

Explain what does a control file contain?

807

How to assign values to data fields in record variables?

764

How to invoke the data pump export utility?

772

How to use existing values in update statements using oracle?

786

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

1865

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

860

How to create a new view in oracle?

829