@udit not sure if i understand the question. If ur db engine supports offset and limit you don’t need anything.
@udit, here’s how I use offset and limit.
select * from table
...
group by col
order by other_col desc
--~ (if (:offset params) "offset :offset")
--~ (if (:limit params) "limit :limit")
It’s probably more idiomatic to use while
instead of if
since there is only a then
block, no else
I think you mean (when ...)
Yeah, my b. Thanks @bostonaholic