Manish Marathe wrote:
> of course, although DISTINCT(name) works
Yes, but writing it that way gives the impression that you are somehow
"applying" DISTINCT only to the "name" column, which you're not. You're
applying it to entire rows.
Oh, and can you please stop top-posting.
Jasper
> On Fri, 2005-10-07 at 12:29 +1300, Jasper Bryant-Greene wrote:
>
>>Manish Marathe wrote:
>>
>>>SELECT DISTINCT(name), date, value FROM table_name ORDER BY date DESC;
>>
>>DISTINCT is not a function. The above (if it even works) is exactly
>>equivalent to:
>>
>>SELECT DISTINCT name, date, value FROM table_name ORDER BY date DESC;
>>
>>and will match distinct rows (that is, combinations of name, date and
>>value).
>>
>>--
>>Jasper Bryant-Greene
>>Freelance web developer
>>http://jasper.bryant-greene.name/
>>
>
>
>
>
>
--
Jasper Bryant-Greene
Freelance web developer
http://jasper.bryant-greene.name/
