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);
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