如何在SQL中选择10个Top记录

i have a table in my database i want to select 10 top post than have must view count what is good query for that?

我在我的数据库中有一个表我想选择10个*帖子而不是必须查看计数什么是好的查询?

2 个解决方案

#1

i used this query

我用过这个查询

select TOP(10) * from tblNews order by viewcount desc

#2

select top 10 * from tablename