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 is normalisation?what are its uses?

2207

Is rowid unique in oracle?

938

How to create a stored function in oracle?

1037

How to calculate date and time differences in oracle?

991

What are ddl statements in oracle?

1014

Explain the use of rows option in imp command.

1041

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2189

How do we represent comments in oracle?

1000

Explain the use of inctype option in exp command.

976

What is difference between sid and service name in oracle?

904

What is a directory object?

1023

How to resolve name conflicts between variables and columns?

978

How do we get field details of a table?

932

Is oracle a language?

897

What is oracle open database communication (odbc)?

960