106 reputation
4
bio website none
location Berlin, Germany
age 28
visits member for 2 years, 11 months
seen Aug 19 '12 at 9:52

Telematics Master student and hobby Python coder.


Sep
15
comment Select only neighbour rows who pass a where-test
I don't understand that at all. What are you doing? What is location2, for example? Why is there no , between the tables in your FROM clause?
Sep
15
comment Select only neighbour rows who pass a where-test
@Aaron Bertrand: It is on purpose that I don't ask for a database specific answer. If you know an easy solution for database X or Y there is no problem adding it as a solution. The real question is, how to solve it with standard SQL, though. I think every well known database should have some way of solving any task out of the standard solvable task set.
Sep
15
comment Select only neighbour rows who pass a where-test
Yes, I didn't tag it with sqlite3 on purpose. If there are better solutions in other dbs it is great additional information, even if I can't use it right now.
Sep
15
awarded  Supporter
Sep
14
awarded  Student
Sep
14
answered Select only neighbour rows who pass a where-test
Sep
14
awarded  Editor
Sep
14
revised Select only neighbour rows who pass a where-test
deleted 12 characters in body
Sep
14
asked Select only neighbour rows who pass a where-test
Sep
14
awarded  Autobiographer