subject:"min \(\) \- sql troubles"

Re: min () - sql troubles

2001-04-24 Thread Bob Hall

>Hi >SQL troubles: >I have a table containing 4 columns: "name" - string, "distance"- >double, >"speed" - time and "id" - AUTO_INCREMENT (Primery key) >I want a list of the fastest (speed) runner (name) of each distance and >the >speed. >I use: >select name, distance, min(speed) from table1 group

RE: min () - sql troubles

2001-04-23 Thread Braxton Robbason

EMAIL PROTECTED] Subject: min () - sql troubles Hi SQL troubles: I have a table containing 4 columns: "name" - string, "distance"- double, "speed" - time and "id" - AUTO_INCREMENT (Primery key) I want a list of the fastest (speed) runner (name) of each distance and

min () - sql troubles

2001-04-23 Thread Christian Wix

Hi SQL troubles: I have a table containing 4 columns: "name" - string, "distance"- double, "speed" - time and "id" - AUTO_INCREMENT (Primery key) I want a list of the fastest (speed) runner (name) of each distance and the speed. I use: select name, distance, min(speed) from table1 group by distanc