select * from tb A where not exists (select 1 from tb B where A.time=B.time and A.total<B.total and A.outtotal>B.outtotal)
SELECT * FROM TT5 A WHERE NOT EXISTS( SELECT 1 FROM TT5 WHERE A.`time`=`time` AND( (A.`total`<`total`) OR (A.`total`=`total` AND A.`outtotal`<`outtotal`) ) )
SELECT * FROM table a WHERE (SELECT COUNT(*) FROM table b WHERE a.time=b.time AND IF(a.total=b.total,a.outtotal<b.outtotal,a.total<b.total))<1;
版主不愧是版主啊,我就卡在后面那个Where语句了,不知道怎么写 WHERE A.`time`=`time` AND( (A.`total`<`total`) OR (A.`total`=`total` AND A.`outtotal`<`outtotal`) ) ) 给力,那要是多了呢?是不是继续增加OR?
from tb A
where not exists (select 1 from tb B where A.time=B.time and A.total<B.total and A.outtotal>B.outtotal)
SELECT 1 FROM TT5 WHERE A.`time`=`time`
AND(
(A.`total`<`total`)
OR
(A.`total`=`total` AND A.`outtotal`<`outtotal`)
)
)
FROM table a
WHERE (SELECT COUNT(*)
FROM table b
WHERE a.time=b.time AND
IF(a.total=b.total,a.outtotal<b.outtotal,a.total<b.total))<1;
WHERE A.`time`=`time`
AND(
(A.`total`<`total`)
OR
(A.`total`=`total` AND A.`outtotal`<`outtotal`)
)
)
给力,那要是多了呢?是不是继续增加OR?