2011/6/25 Cecil Westerhof <[email protected]>
> With LIMIT you can get the first N records of a SELECT. Is it also possible
> to get the last N records?
>
Thanks for the answers. I had thought about both options, but was wondering
if I had missed something better. I original opted for the LIMIT/OFFSET
option (because the order is important), but after following the link I
found that this will be an ineffective way in the long run. That is way I
choose the DESC way in combination with tac. (I am using a bash script.):
selectStr="
SELECT categories.desc
, weights.measureDate
, weights.weight
, weights.fat
, weights.water
, weights.muscle
FROM weights
, categories
WHERE categories.desc = 'Cecil'
AND weights.categoryID = categories.id
ORDER BY weights.measureDate DESC
LIMIT ${SHOW_NUMBER}
;
"
for record in $(echo "${selectStr}" | sqlite3 ${DATABASE} | tac) ; do
--
Cecil Westerhof
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
