How to retrieve first and last records from a table?
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 |
Post New Answer View All Answers
How many types of tables are there in oracle?
How to convert a string to a date in oracle database?
How many memory layers are in the oracle shared pool?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
Explain an integrity constrains?
What is analyze command used for?
What is oracle rownum?
How many file formats are supported to export data?
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?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What are the restrictions in a oracle read only transaction?
How to see the table columns used in an index?
What is the difference between view and materialized view in Oracle?
How to do a full database export?