56,678
社区成员
发帖
与我相关
我的任务
分享
create table c_test
(
cid integer primary key auto_increment,
cvalue1 integer,
cordernumber integer,
cname varchar(30)
);
insert into c_test (cvalue1, cordernumber, cname) values (111, 222, 'hi');
insert into c_test (cvalue1, cordernumber, cname) values (222, 111, 'hi');
insert into c_test (cvalue1, cordernumber, cname) values (333, 333, 'hi');
insert into c_test (cvalue1, cordernumber, cname) values (555, 666, 'hi');
insert into c_test (cvalue1, cordernumber, cname) values (666, 555, 'hi');
select cname, cvalue1,
max(cordernumber), min(cordernumber) from c_test
group by cname
cname,cvalue1,max(cordernumber),min(cordernumber)
----- ------- ----------------- -----------------
hi, 111, 666, 111
select cname, cvalue1,
max(cordernumber), min(cordernumber) ,
MAXTestFunction(cordernumber, cvalue1) as 'What I Want A',
MINTestFunction(cordernumber, cvalue1) as 'What I Want B',
sum (column1), sum(column2), count(column3), .....
from c_test
group by cname
不知 MySQL 是不是有类似的方法可以实现这个??
select cname, cvalue1,
max(cordernumber), min(cordernumber) ,
(XXXXXXX) as '列A,该列的 cordernumber = max(cordernumber)',
(YYYYYYY) as '列B,该列的 cordernumber = min(cordernumber)'
sum (column1), sum(column2), count(column3),,,, sum(column30)
from c_test
where 1=1 && 2=2 && (有很多其他条件在这里)
group by cname
select *
from (select * from c_test order by cordernumber desc limit 1) a,(select * from c_test order by cordernumber asc limit 1)
select cname, cvalue1,
max(cordernumber), min(cordernumber) , sum (column1), sum(column2), count(column3), .....
from c_test
group by cname
[/quote]
不明白你想要什么
select cname, cvalue1,
max(cordernumber), min(cordernumber) , sum (column1), sum(column2), count(column3), .....
from c_test
group by cname
select cvalue, corderNumber
from c_test
where corderNumber = (select max(corderNumber) from c_test)
union
select cvalue.corderNumber
from c_test
where orderNumber = (select min(corderNumber) from c_test)