On Thu, 27 Jun 2002 12:53:21 -0400, Martijn van Oosterhout wrote:
> Have a look at DISTINCT ON. It works well for this sort of thing.
>
Yes, but if I have
1 2 3
2 2 3
3 3 4
4 2 3
5 2 3
I want
1 2 3
3 3 4
4 2 3
left in the database. I think using distint on would yield
1 2 3
3 3 4
only (provided my key isn't part of unique on). But then, I need to read
up a bit more to make sure.
Thanks!
L
--
Laurent Duperval <mailto:lduperval(at)videotron(dot)ca>
"The proof that IBM didn't invent the car is that it has a steering wheel and
an accelerator instead of spurs and ropes, to be compatible with a horse."
-