MySql does not provide the top method. But he has the limit method that provides the same functionality.

SELECT * FROM `tfidf` order by weight desc limit 1, 10830

SELECT * FROM `tfidf` order by weight desc limit 10