On 2014-09-13, 10:07 PM, jose isaias cabrera wrote:
I know that the IN clause contains a list of something. I.e.IN ('2014-01-01', '2014-01-02', '2014-01-03', '2014-01-04', '2014-01-05') So the question is, is there a shorter way for one to say something like, IN ('2014-01-01', ..., '2014-01-05') where the content of the IN would have the first item and the last item of the list, but that's it? Thanks.
You're talking about a range/interval. In SQL it is spelled like this: BETWEEN '2014-01-01' AND '2014-01-05' -- Darren Duncan _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
