jday@xxxxxxxxxxxxxx wrote on 15.04.2005 16:42:
select max(lastupdate),prodid from tablename group by prodid
Even better :)
Thomas
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
jday@xxxxxxxxxxxxxx wrote on 15.04.2005 16:42:
select max(lastupdate),prodid from tablename group by prodid
Even better :)
Thomas
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
|