select* from employees where rowid=(select min(rowid) from employees) uni

How to retrieve first and last records from a table?

Question Posted / avnish srivastava-test engg fc

Answer Posted / avnish srivastava-test engg fc

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how can we store any pdf file in oracle

2111

what is the scripts in data base?

2095

What do you mean by merge in oracle and how can you merge two tables?

920

How to get last row id?

950

Explain the features of oracle?

994

When system tablespace is created?

981

How to view the data files in the current database?

1054

What is a snapshot in oracle database?

981

What is the difference between sharding and replication?

978

How to assign a table row to a record variable?

980

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2447

Differentiate between post-database commit and post-form commit?

989

How to use "in out" parameter properly?

1009

Explain the use of record option in exp command.

956

What are the common oracle dba tasks?

1084