Why does MySQL select offset not work in pyspark?

Question

select distinct day 
from t1 
order by 1 desc limit 1,1 

should return the second latest date in t1, but this error is thrown:

ParseException: mismatched input ',' expecting {, ';'}