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