Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.mixmin.net!weretis.net!feeder1.news.weretis.net!news.szaf.org!news.gnuher.de!.POSTED!not-for-mail From: Steffen Mutter Newsgroups: comp.lang.python Subject: Improve reduce functions of SQLite3 request Date: Sun, 3 Feb 2013 09:46:08 +0000 (UTC) Organization: GNUher.de Lines: 42 Message-ID: NNTP-Posting-Host: localhost Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: nerdhammel.gnuher.de 1359884768 1663 127.0.0.1 (3 Feb 2013 09:46:08 GMT) X-Complaints-To: newsmaster@gnuher.de NNTP-Posting-Date: Sun, 3 Feb 2013 09:46:08 +0000 (UTC) User-Agent: XPN/1.2.6 (Street Spirit ; Linux) Xref: csiph.com comp.lang.python:38100 Hi, I am writing some code to manage handball leagues more easy. Problem: MISSON: Get single club ids glued together with the shortest teamname. EXAMPLE: SELECT homenr as nr, home as club FROM Runde20122013 WHERE place="karlsruhe" UNION SELECT guestnr as nr, guest as club FROM 20122013 WHERE place="karlsruhe" GROUP BY nr LIMIT 10 ACTUAL RESULT: 359|TV Calmbach 21101|SG Heidel/Helm 21236|JSG Neuth/Büch 23108|TG Eggenstein 23108|TG Eggenstein 2 23109|TV Ettlingenw 23109|TV Ettlingenw 2 23112|TSV Jöhlingen 23112|TSV Jöhlingen 2 23112|TSV Jöhlingen 3 NEEDED RESULT: 359|TV Calmbach 21101|SG Heidel/Helm 21236|JSG Neuth/Büch 23108|TG Eggenstein 23109|TV Ettlingenw 23112|TSV Jöhlingen the nr needs to be unique together with the shortest clubname returned by the where clause. Any hints how to get this done either with SQLite3 tecneeqs or python functions. Kind regards. SMut