SELECT DISTINCT(bid), id, taskId,description FROM `*****` WHERE taskId < 20 GROUP BY bid ORDER BY id DESC 可以肯定的是,不止一条数据,但无论是怎么取,都只是取了每个bid的第一条,order by根本不起作用
不是标准的SQL语句SELECT bid, id, taskId,description FROM `*****` WHERE taskId < 20 GROUP BY bid, id, taskId,description ORDER BY id DESC
SELECT DISTINCT(bid), id, taskId,description FROM `*****` WHERE taskId < 20 GROUP BY bid ORDER BY id DESC这语句有问题啊 ,看不出来想要什么按bid分组了 还DISTINCT?
SELECT * FROM (SELECT * FROM `***` WHERE taskId < 30 ORDER BY id DESC) as newTab GROUP BY bid 如何?
可以肯定的是,不止一条数据,但无论是怎么取,都只是取了每个bid的第一条,order by根本不起作用
FROM `*****`
WHERE taskId < 20
GROUP BY bid
ORDER BY id DESC这语句有问题啊 ,看不出来想要什么按bid分组了 还DISTINCT?
如何?