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

what are the security recommendations while using mysql? : Sql dba

1046

What is composite primary key in sql?

935

What is package in pl sql with an examples?

967

what is online transaction processing (oltp)? : Sql dba

931

what is sql server agent? : Sql dba

1027

When can we use the where clause and the having clause?

966

discuss about myisam key cache. : Sql dba

973

What is the non-clustered index in sql?

1006

How does stored procedure reduce network traffic?

965

Where do we use pl sql?

940

What is an exception in PL/SQL? What are the two types of exceptions?

1189

I need a function for a train ticket reservation please answer it thanks in advance

957

How do you declare a user-defined exception?

958

How do you write an index?

912

What is a loop in sql?

935