SELECT * from empl WHERE ROWID IN ( SELE

How to retrieve first and last records from a table?

Question Posted / abc

Answer Posted / abc

SELECT * from empl WHERE ROWID IN (
SELECT MAX(ROWID) FROM empl
UNION
SELECT MIN(ROWID) FROM empl
);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the use of constraints option in exp command.

1009

What is a system tablespace?

1021

How to initialize variables with default values?

1185

What is the difference between alert log file and tarce file ?

2118

What is a nvl function? How can it be used?

972

How to commit the current transaction in oracle?

1062

What are the limitations oracle database 10g xe?

994

Explain user account with reference to oracle.

941

How many categories of data types?

954

Calculate difference between 2 date / times in oracle sql?

1005

What is sequence?

1029

How to assign values to data fields in record variables?

988

What is an oracle tablespace?

1006

How to install oracle odbc drivers?

1052

What is the difference between substr & instr functions?

1156