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

What is the scope of a local variable?

994

What is the order of defining local variables and sub procedures/functions?

1003

What is instant client oracle?

972

Explain the use of analyse option in exp command.

1063

How to view existing locks on the database?

993

Explain integrity constraints?

1056

What is system tablespace?

1039

How to convert numbers to characters in oracle?

966

What do you mean by group by clause?

977

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

2186

How do I recompile a procedure in oracle?

907

How does the on-delete-cascade statement work?

1058

What is a snapshot in oracle database?

970

How to shutdown your 10g xe server from command line?

1013

What is ASM (Automatic Storage Management) in Oracle?

1121