cl-dbi
cl-dbi copied to clipboard
Range of elements
trafficstars
How could I do this query (from PostgreSQL SQL dialect)?
SELECT * FROM student ORDER BY id DESC LIMIT (20-10+1) OFFSET 10;
(ql:quickload :sxql)
(select :*
(from (:student))
(order-by :id (:desc :id))
(limit (- 20 (+ 10 1)))
(offset 10))
P.S.
This questions was not for here, it was for SxQL.
Sorry, sorry.