如何限定查询后返回结果的个数?

[cheyo车油]

SELECT bName 书名,bReadTimes 浏览次数 FROM books ORDER BY bReadTimes DESC

我想让这条sql语句只返回10个记录,要加什么参数?

[伍子V5]

SELECT top 10 bName 书名,bReadTimes 浏览次数 FROM books ORDER BY bReadTimes DESC

[txlicenhe]

SELECT top 10 bName 书名,bReadTimes 浏览次数 FROM books ORDER BY bReadTimes DESC

[cbzdream]

SELECT top 10 bName 书名,bReadTimes 浏览次数 FROM books ORDER BY bReadTimes DESC

[aierong]

top 10