Îʸö¼òµ¥µÄSql²éѯÎÊÌâ

±íAÖÐÄÚÈÝ:
Id  Name
1  aa
2  aa
3  bb
4  cc
5  cc
6  cc

ÓÃÒ»Ìõ²éѯÓï¾ä,·µ»Ø½á¹û:
aa  2
bb  1
cc  3

---

SQL code:
select name,max(ID)ID from tb group by name

---

SQL code:
SELECT NAME,MIN(ID)ID from TB GROUP BY NAME ORDER BY NAME

---

SQL code:
select * from tb t
where not exists(select 1 from tb where name=t.name and id>t.id)

---

SQL code:
--¸ã錯
select name ,count(*) from tb group by name

---

SQL code:
--> Title : Generating test data #t
--> Author : wufeng4552
--> Date : 2009-11-10 14:49:16
if object_id('tempdb.dbo.#t') is not null drop table #t
go
create table #t (Id int,Name nvarchar(4))
insert into #t
select 1,'aa' union all
select 2,'aa' union all
select 3,'bb' union all
select 4,'cc'