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 use 'mysql' to run sql statements? : Sql dba

1037

What is the difference between cluster and non-cluster index?

1092

How do I view a procedure in sql?

954

What is difference between stored function and application function?

1173

How to prepare for oracle pl sql certification?

1047

how to concatenate two character strings? : Sql dba

1078

Is sql pronounced sequel or sql?

1247

Explain the components of sql?

1043

What is vector point function?

1026

How can triggers be used for the table auditing?

1049

What is indexing oracle sql?

1085

What is procedure explain with program?

996

what are the t string functions available in tsql? : Transact sql

992

What is error ora-01000: maximum open cursors exceeded

1125

what is error ora-03113: end-of-file on communication channel?

1149