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 authentication modes in sql server? : Sql dba

1123

what is the stuff function and how does it differ from the replace function? : Sql dba

1111

How to select all records from the table?

1188

Is sql pronounced sequel or sql?

1340

What sql does db2 use?

1030

What is localdb mssqllocaldb?

1115

What is a recursive join sql?

1119

How do sql triggers work?

1096

describe transaction-safe table types in mysql : sql dba

1065

Can variables be used in sql statements?

1075

Is postgresql a server?

1114

What is sqlcommand?

1073

How many sql statements are used?

1075

How do you remove duplicate records from a table?

986

Why do we create stored procedures & functions in pl/sql and how are they different?

995