SELECT * FROM Product WHERE (id IN(SELECT MAX([id]) FROM Product GROUP BY userid)) ORDER BY id DESC
实际应用:用户发布产品时,保证列表页每个用户只显示最新的一条。
SELECT * FROM Product WHERE (id IN(SELECT MAX([id]) FROM Product GROUP BY userid)) ORDER BY id DESC
实际应用:用户发布产品时,保证列表页每个用户只显示最新的一条。