How to retrieve first and last records from a table?
Answer Posted / girija.112
select *
from employees
where rowid = (select max(rowid)
from employees)
or rowid =(select min(rowid)
from employees)
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What happens if variable names collide with table/column names?
What are the predefined tablespaces in a database?
How to add a new column to an existing table with a default value?
Why do we need oracle client?
How to use subqueries with the in operator using oracle?
What is a tns service name?
What is meant by joins?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
What is oracle analytical function?
How to convert dates to characters in oracle?
What is integrity and what is constraint??Explain with example
What are ddl statements in oracle?
What are the execution control statements?
How to write text literals in oracle?
What do you mean by cdb and pdb in oracle 12c?