Monday, May 2, 2011

First And Last row in table

First row in Emp Table

SELECT *FROM emp where rowid=(SELECT min(rowid) from emp);
Last row in Emp table

SELECT *FROM emp where rowid=(SELECT max(rowid) from emp);

both First and Last rows in Emp table

SELECT *FROM emp where rowid in (SELECT min(rowid) from emp union select max(rowid) from emp);

No comments:

Post a Comment