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 is #table in sql?

1098

What is a column in a table?

1124

What are the key differences between SQL and PL SQL?

1211

What is the purpose of the sql select top clause?

1110

Can a view be mutating? If yes, then how?

1026

What is example of database?

1056

What is the difference between function, procedure and package in pl/sql?

1257

Which is better join or inner query?

1046

what is the difference difference between procedure and packages

10405

What is equi join in sql?

1073

What is %s in sql?

1011

What is the difference between delete and truncate commands?

1037

how would concatenate strings in mysql? : Sql dba

1093

Does truncate require commit?

971

Which one is better sql or oracle?

968