Monday, March 27, 2017

How to Find Last Row in the Table from SQL query!

Last Row in TABLE 

The only way to get the last row is for the Developer to have put a tiemstamp or some sequence number in there.Then you can

select * from t where
x = (select max(x) from t;

select * from emp
where rowid in(select max(rowid) from emp);

select * from emp
minus
select * from emp
where rownum < (select count(*) from emp);

No comments:

Post a Comment