Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot

Re: Help with manipulating data from a database??

by mikeB (Friar)
on Jul 02, 2007 at 15:30 UTC ( #624482=note: print w/replies, xml ) Need Help??

in reply to Help with manipulating data from a database??

You could use ForgotPasswordAgain's initial "won't work" idea as a subquery to grab the full record for the shortest distances.
select a.* from table_name a join ( select min(distance) as min_dist, service_id as min_id from table_name group by service_id ) b on (a.distance = min_dist and a.service_id = min_id);
If (service_id, distance) is not a unique key, this will return all the stop_references with the minimal distance. This may be a Good Thing, depending on the application. If you want only one result, adding the appropriate ORDER BY and LIMIT 1 clauses should do the trick.
/is not a guru //tried it and it worked for me

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://624482]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (4)
As of 2022-01-18 17:40 GMT
Find Nodes?
    Voting Booth?
    In 2022, my preferred method to securely store passwords is:

    Results (53 votes). Check out past polls.