球一句SQL查询 - .NET技术 / ASP.NET

select count(autoID) as linecount,webgroup from flinkIn group by webgroup order by linecount

分组结果如下，可如何取出最小值30的webGroup1003linecount,webgroup  
30 1003
500 1002
524 1001




这写取出的是30而不是1003
select min(linecount) from (select count(autoID) as linecount,webgroup from flinkIn group by webgroup) as tmptable 


应该怎么写啊

---

混乱！！
给出表结构，
和你最终要的数据结构！！

---

top 1不行么？

---

既然已经是升序 就最小的 top 1就足够了啊

---

linecount,webgroup  
30 1003
500 1002
524 1001


要的是1003啊

---

取出的1003在给变量，存储过程中的

---

--30 1003
--500 1002
--524 1001

declare @tmptb table(字段1 int,字段2 int)
insert into @tmptb select 30,1003
union all select 500,1002
union all select 524,1001

select * from @tmptb where 字段1=(select min(字段1) from @tmptb)

---

如果linecount=30只有一行
select top 1 * from (select count(autoID) as linecount,webgroup from flinkIn group by webgroup) order by linecount

如果有多行
select * from (select count(autoID) as linecount,webgroup from flinkIn group by webgroup) t1
where t1.linecount = (select min(linecount) from (select count(autoID) as linecount,webgroup from flinkIn group by webgroup)

---

SQL code

---

Code highlighting produced by Actipro CodeHighlighter (freeware)