sql - Access query: Group get latest -
i have query may return more 1 record, when happens need latest record according instance field (tinyint). trying create query executes first query , group query. way if returns 1 doesn’t alter result cause record latest.
this on microsoft access 2003 query.
use top: select top 1 field1, field2 mytable order instance desc
.
thats fastest way far.
Comments
Post a Comment