Posted by Duane Phillips on 08/29/06 05:27

OK. I posted my answer to the wrong message. *sigh*. Not my day.

And Group By has been handled enough by the other posters...

Cheers...

"Duane Phillips" <duane.phillips@askme.askme> wrote in message
news:-audnb5pUZioDW7ZnZ2dnUVZ_rOdnZ2d@giganews.com...
> It works basically the same as in other SQL driven databases, excepting
> that it uses single quotes for instead of double.
>
> Sample of character, numerical, and table to table link in WHERE clause:
>
> WHERE table1.field1 = 'some parameter' AND table1.field2 = 6 AND
> table1.field5 = table3.field1
>
> With character and date fields use single quote marks around the parameter
> value, and skip the single quotes for numerical arguments.
>
> This is the basic structure, but you can do far more operators and
> nestings... but it is basically SQL 92 compliant (depending on your
> version of MySQL, which you did not specify).
>
> Cheers!
>
> ~ Duane Phillips.
>
> "jatrojoomla" <jatrojoomla@gmail.com> wrote in message
> news:1156770696.026364.285250@74g2000cwt.googlegroups.com...
>>I am trying to use GROUP BY cluse, what is the utility of this cluse in
>> MySQL
>> plz. any body tell me
>>
>
>

[Back to original message]