OpenLoop

Say I'm trying to select some records from table "info" where "x > 5" and "y < 5" and z is distinct in the results. so i would get at most ONE record that meets the condition for each z. I tried
but that will return distinct combinations of x,y, and z not just distinct z's. Any ideas?

DaWei

I think it's just a matter of how you used (placed) the token, DISTINCT. You can achieve the same results with:

SELECT x, y, z
FROM info
WHERE x > 5 AND y < 5
GROUP BY z

(assuming I read your intentions correctly, there's a DISTINCT possibility I didn't)

__________________
Abstraction doesn't make it impossible to write bad code; it makes it possible to write superior code.
Contributor's Corner: Grumpy on C++ Exceptions DaWei on Pointers

OpenLoop

After 20+ tries i got it. Thanks.