急求一条查询语句

[joelbh]

在一个文章表里,有7种类别的文章记录,现在想从每种类别抽取最新的一条记录,总共抽取7条记录,这条查询语句该怎么写?

[bugchen888]

select * from tablename a where not exists (select 1 from tablename b
where a.类别=b.类别
and a.id<b.id)

[rivery]

类别固定的话，建立个视图。
select top 1 * from tablename where type='1' order by colname
union
select top 1 * from tablename where type='2' order by colname
...

[wukele]

select * from wenzhangtable exists(select id,max(shijian) from wenzhangtable groupby类别 )

[ztfuqing]

select top 1 from biao where class_id in(select class_id from biao)

[zlp321002]

--取最新记录方法,参考:
http://blog.csdn.net/zlp321002/archive/2005/03/02/307667.aspx

[wangdehao]

select * from Tablename where id in(select MAX(id) from Tablename group by 类别)