On Thu, Sep 6, 2012 at 1:22 AM, Ian Kelly <ian.g.ke...@gmail.com> wrote: > The lack of an ORDER BY is the least of the problems with that SQL. > He's also using LIMIT without OFFSET, so the only thing that the > 'item' argument changes is how many rows are returned (all but one of > which are ignored), not which one is actually fetched.
No, he's using the two-arg form of LIMIT. > It's a bit sad that these are touted as answers to interview > questions. I wouldn't hire anybody who gave answers like these. The code does not work as posted; there are args missing from the INSERT example, for, uhh, example. It makes it hard to evaluate the quality of the code, in some places. I'm not sure what these posts are supposed to be, but I hope they're not being held up as model answers to interview questions. For a start, I can't find any sort of clear questions. Or is the code itself the question and "How would you improve this"? ChrisA -- http://mail.python.org/mailman/listinfo/python-list
