Why does MySQL select offset not work in pyspark?

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 {, ';'}