You are going to want to do something like the following (I didn’t check this for errors):
SELECT TOP 200 * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY Name DESC) AS RowNum FROM dbo.TableName WHERE Country LIKE @Country) AS newTableName WHERE newTableName.RowNum BETWEEN @start AND @end
If you find yourself needing more advanced functionality you can try our paid plugin: SQL Database Connector Pro Plugin | Bubble