LIMIT specifies which rows to return in the result. Cursors allow dynamic row retrieval. The difference between LIMIT and cursors is that LIMIT specifies the rows as part of the SELECT, while cursors allow dynamic fetching of rows. Both LIMIT and cursors offer new ways to tailor your queries so that you obtain exactly the desired results.