有文章分类表和文章表两个表,表结构分别是:
Article
Id CategoryId Title LastUpdatedTime(文章最后更新时间)
Category
Id CategoryName
需要查询出 最近有文章更新的10个 CategoryName
请教大家SQL语句该怎么写? 数据库是SQL Server,谢谢!
select top 10 distinct c.Id ,c.CategoryName from Artical a join Category c on IsNull(a.CategoryId,0) = c.Id order by a.LastUpdatedTime desc