ÇóÒ»sqlÓï¾ä - .NET¼¼Êõ / ASP.NET

id name kecheng chengji
1 ÕÅÈý ÓïÎÄ 70
2 ÕÅÈý Êýѧ 90
3 ÀîËÄ ÓïÎÄ 85
4 ÀîËÄ Êýѧ 87
5 ÀîËÄ Ó¢Óï 88
6 ÍõÎå ÓïÎÄ 79
7 ÍõÎå Êýѧ 90
8 ÍõÎå Ó¢Óï 82


ÓÃÒ»ÌõsqlÓï¾ä²éѯÈýÃſγ̵ijɼ¨¶¼´óÓÚ80·ÖµÄѧÉúÐÕÃû

---

SQL code:
select name, count(chengji) as ×Ü·Ö from ±íÃû where ×Ü·Ö>80 group by name

---

1Â¥µÄ¾Í¿ÉÒÔ£¡

---

SQL code:
select name from tablename where sum(chengji)>80 group by name

---

select [name] from biao group by [name] having (sum(chengji)/count([name])) > 80

ÊÔÊÔ°É¡£¡£¡£¡£¡£¡££¬Æ¾¸Ð¾õдµÄ

---

ÊÇÈý¿Æ¶¼´óÓÚ£¸£°àÏ

---

ÊÇÿ¿Æ³É¼¨¶¼´óÓÚ80·Ö£¬²»ÊÇ×ܳɼ¨

---

select name from biao where name not in (select name from biao where chengji<80)

---

select name from [tableName] where chengji > 80 group by name having count(*) >= 3

---

ÒýÓÃ

1Â¥µÄ¾Í¿ÉÒÔ£¡

ºú˵£¬Â¥ÉϵĶ¼ÊÇ´íµÄ¡£
SQL code:


select [name] from (select [name], min(chengji) min