【www.gdgbn.com--php与数据库】

 
 //方法二
 

 select name,content,imgurl,synops教程is from (
select name,content,imgurl,synopsis ,row_number() over (partition by name order by content) as rn
from table1
) t where t.rn=1

//方法二

if object_id("[tb]") is not null drop table [tb]
create table [tb]([name] varchar(1),[content] varchar(5),[imgurl] varchar(5),[synopsis] varchar(6))
insert [tb]
select "a","不同1","不同1","可不填" union all
select "a","不同2","不同2","可不填" union all
select "a","不同3","不同3","可不填" union all
select "b","不同4","不同4","可不填" union all
select "b","不同5","不同5","可不填" union all
select "c","不同6","不同6","可不填"

select * from [tb]

with tt
as(
select id = row_number() over (partition by name order by name ),* from tb )

select  [name], [content], imgurl, synopsis from tt where id  = 1

本文来源：http://www.gdgbn.com/jiaocheng/25979/