Select * from emp where rowid=(select max(rowid) from emp) or rowid=(select

Hi Everyone,
How to get fist and last record from a table in oracle?

Thanks in advance

Question Posted / ataullah

Answer Posted / ataullah

Select * from emp where rowid=(select max(rowid) from emp) or rowid=(select min(rowid) from emp)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to order siblings in oracle hierarchy queries?

1047

What is function and procedure in pl sql?

1046

Show how functions and procedures are called in a pl/sql block.

1127

What is nvl?

1065

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

997

What is the difference between Union and Union all. Which is faster.

1403

Is record in pl sql?

975

What is composite data type in pl sql?

1113

How can I tell if sql is running?

1066

What is informix sql?

979

how many tables will create when we create table, what are they? : Sql dba

1075

Explain correlated query work?

1056

What is data type in database?

994

What is cartesian join in sql?

1132

what is the difference between $message and $$message? : Sql dba

998