Select results from the middle of a sorted list?

Question

I have a simple table with 300 rows, and after ordering it, I want to select rows 11-50. Will I limit myself to 50 and somehow delete the top 10 lines?

Answer 1

SELECT * 
FROM table
ORDER BY somecolumn
LIMIT 10,40 

MySQL:
LIMIT , SELECT. LIMIT , ( , ).
, . 0 ( 1)

Answer 2

LIMIT , :

LIMIT 10, 40

... 11-50, ( 1).