I am making some paging, and I need to make some query and get the result form defined slicing . for example: I need to get all "top" rows in range 20n < x < 40n etc.
SELECT * FROM Reflow
WHERE ReflowProcessID = somenumber
ORDER BY ID DESC;
and now I need to make my sliding by column called ID .
Any suggestions how to so ? I need to run my query on mysql, mssql, and oracle.
See Question&Answers more detail:os