Well, assuming the “maxdate” is always going to be found in the database, you could always do that in a subquery, like this:
select *
from TRANSACTIONS
where TRANSDATE = (SELECT MAX(transdate) FROM TRANSACTIONS);
Well, assuming the “maxdate” is always going to be found in the database, you could always do that in a subquery, like this:
select *
from TRANSACTIONS
where TRANSDATE = (SELECT MAX(transdate) FROM TRANSACTIONS);