Hi, Can someone please tell me how this query can be better?? I need the "clubrecords" from atlethics database for onderdeel,categorie,inoutdoor.
select onderdeel,categorie,MIN(prestatie) as prestatie,inoutdoor,naam,datum,wedstrijd,plaats FROM runtijden GROUP BY onderdeel,categorie,inoutdoor having count(*)=1 order by 1 In the onderdeel field there are some that has need a MAX prestatie . So i want some onderdeel with a MIN(prestatie) and some with a MAX(prestatie). And the srcipt has now some presatie that are random.. Please help. TIA, Ed. ______________________________________ Scanned and protected by Inflex http://pldaniels.com/inflex --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php