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

How many types of tables are there in oracle?

1043

How to convert a string to a date in oracle database?

1031

How many memory layers are in the oracle shared pool?

1160

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

987

Explain an integrity constrains?

1122

What is analyze command used for?

1044

What is oracle rownum?

931

How many file formats are supported to export data?

1195

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?

2807

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2604

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4500

What are the restrictions in a oracle read only transaction?

1008

How to see the table columns used in an index?

999

What is the difference between view and materialized view in Oracle?

1126

How to do a full database export?

1085