Hi everyone, Can you please share optimized query for pagination spark sql?
In Ms SQL Server, They have supported "offset" method query for specific row selection. Please find the following query Select BusinessEntityID,[FirstName], [LastName],[JobTitle] from HumanResources.vEmployee Order By BusinessEntityID --OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY Is this support OFFSET method in spark sql? Kindly share the useful details. Regards, Ravi
