Thread: Min values?

Min values?

From
"J.C.M. van der Kwast"
Date:
Hi,
 
I don't seem to grasp the anwser on this problem. I've got a table with points, place_id's and distance between points and place_id. I want to select the points and place_id with smallest distance. I've tried statemeants like this but with no results that I like:
 
Select points, place_id, distance from table
group by points, place_id, distance
having points= (select points from table having distance = (select min(distance) from table)
 
The only result I'm getting is the min value of distance. I want to have the points, place_id with distance = min(distance). Any suggestions?
 
greetz Sjors  

Re: Min values?

From
Christoph Haller
Date:
>
> I don't seem to grasp the anwser on this problem. I've got a table
with poi=
> nts, place_id's and distance between points and place_id. I want to
select =
> the points and place_id with smallest distance. I've tried statemeants
like=
>  this but with no results that I like:
>
> Select points, place_id, distance from table
> group by points, place_id, distance
> having points=3D (select points from table having distance =3D (select
min(=
> distance) from table)
>
> The only result I'm getting is the min value of distance. I want to
have th=
> e points, place_id with distance =3D min(distance). Any suggestions?
>
Why not

Select points, place_id, distance from table
WHERE distance =3D (select min( distance) from table) ;

Regards, Christoph