过滤结果日期最大值时

Question

Can anyone advise on what im doing wrong here?

I am trying to select a table full of results, some are duplicates, but the timestamp is different, so I want to filter out by the latest date.

I'm using the following sql query but it just keeps throwing up errors?

$sql = "(SELECT  *
FROM    measrate
WHERE TRANS_TIME = (SELECT MAX(TRANS_TIME) FROM measrate)";

Answer 1

sql = "(SELECT  * FROM    measrate WHERE TRANS_TIME = (SELECT MAX(TRANS_TIME) FROM measrate))";

Forgot last bracket