这个查询怎么写? select c1,mix(c2) from table group by c1 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 写错了。select * from table a where (c1,c2) in (select c1,min(c2) from table b group by c1) 如果能保证在c1相同时c2最小的只有一个的话试一试下面的方法select c1,min(c2),min(c3),min(IDX) from table group by c1 你要什么样的结果呢,如果只是C2的话,呵呵SELECT min(C2) FROM table GROUP BY c1 select * from table a,(select c1,min(c2) as c2 from table group by c1) as b where a.c1 = b.c1 and a.c2 = b.c2 楼上的方法很好。我班门弄斧,请高人指点:select * from TABLE where IDX in(select a from(select select c1,min(c2),min(IDX)as a from TABLE group by c1)as temp) 游标中fetch from和fetch next from 应该是同一个意思吧? 求一条SQL 语句 新手自学请教问题! 问条语句 关于临时结果集的疑问 Access中case关键字的语法问题 插入多行怎么写? 帮帮忙,谢谢 sql空值问题 SQL语句出问题了,好郁闷。。。。。。。。 救命啊~~~~~~~~~~~~~~~~~~!十万火急!快! 怎样断开对某个数据库正在访问的所有连接(SQL server 2000)
select c1,min(c2),min(c3),min(IDX) from table group by c1
SELECT min(C2) FROM table GROUP BY c1
select * from TABLE where IDX in(select a from(select select c1,min(c2),min(IDX)as a from TABLE group by c1)as temp)