ÇòÒ»¾ä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)