Can Dremio SQL LIMIT range like SQL

Hi guys, in MySQL when i want to choose values from 10 to 20, i just need to type LIMIT 10,10 .But in Dremio SQL, that systax will fail. How can i query range on Dremio?

like this:
LIMIT 10 OFFSET 10

1 Like

ohh, thanks you so much