高手帮忙 orz求答案 来人解答一下阿~~~~~ select * from a inner join (select max(mc) as m1,min(mc) as m2 from a group by mc) t on a.mc=t.m1 or a.mc=t.m2 select * from a inner join (select max(mc) as m1,min(mc) as m2 from a ) t on a.mc=t.m1 or a.mc=t.m2
SQL code: select id,max(mc),min(mc),tm from tb group by id,tm
SQL code: select m.* , n.* from (select t.* from a t where mc = (select max(mc) from a where 日期 = t.日期)) m, (select t.* from a t where mc = (select min(mc) from a where 日期 = t.日期)) n where m.日期 = n.日期
