select * from employees where rowid = (select max(rowid)

How to retrieve first and last records from a table?

Question Posted / girija.112

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

Please Help Members By Posting Answers For Below Questions

What happens if variable names collide with table/column names?

1127

What are the predefined tablespaces in a database?

1026

How to add a new column to an existing table with a default value?

987

Why do we need oracle client?

902

How to use subqueries with the in operator using oracle?

1055

What is a tns service name?

962

What is meant by joins?

1029

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2010

What is oracle analytical function?

1057

How to convert dates to characters in oracle?

999

What is integrity and what is constraint??Explain with example

2233

What are ddl statements in oracle?

1031

What are the execution control statements?

1028

How to write text literals in oracle?

1036

What do you mean by cdb and pdb in oracle 12c?

1026