php - 从数据库中检索前 10 个

Question

我有这个查询，但我只想返回基于 num_guess 的前 10 个。我不知道查询的格式。我不知道将 LIMIT 或 TOP 放在哪里。请帮忙!

"SELECT user,num_guess FROM game JOIN difficulty USING (difficulty_no) WHERE difficulty_no=2 ORDER BY num_guess ASC "

Answer 1

使用 limit 10

像这样

"SELECT user,num_guess FROM game 
 JOIN difficulty USING (difficulty_no) 
 WHERE difficulty_no=2 ORDER BY num_guess ASC limit 10"