GROUP BY cluse

[jatrojoomla]

I am trying to use GROUP BY cluse, what is the utility of this cluse in
MySQL
plz. any body tell me

[Jerry Stuckle]

jatrojoomla wrote:

I am trying to use GROUP BY cluse, what is the utility of this cluse in
MySQL
plz. any body tell me

I'm not sure what you're asking. What are you trying to do?

P.S. This isn't a php question. It's strictly a SQL question.
alt.php.sql and php.general removed from the reply.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[IchBin]

jatrojoomla wrote:

I am trying to use GROUP BY cluse, what is the utility of this cluse in
MySQL
plz. any body tell me

Not sure, by your question, if you are asking how to use GROUP BY
clause. If you are then look here:

http://dev.mysql.com/doc/refman/5.1/...modifiers.html

--
Thanks in Advance...
IchBin, Pocono Lake, Pa, USA http://weconsultants.phpnet.us
'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)

[Duane Phillips]

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" <ja*********@gmail.comwrote in message
news:11**********************@74g2000cwt.googlegro ups.com...

>I am trying to use GROUP BY cluse, what is the utility of this cluse in
MySQL
plz. any body tell me

[Justin]

example: SELECT * FROM abc WHERE name='abc' GROUP BY age

jatrojoomla wrote:

I am trying to use GROUP BY cluse, what is the utility of this cluse in
MySQL
plz. any body tell me

[Duane Phillips]

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" <du************@askme.askmewrote in message
news:-a******************************@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" <ja*********@gmail.comwrote in message
news:11**********************@74g2000cwt.googlegro ups.com...

>>I am trying to use GROUP BY cluse, what is the utility of this cluse in
MySQL
plz. any body tell me

[Christoph Burschka]

Justin wrote:

example: SELECT * FROM abc WHERE name='abc' GROUP BY age

jatrojoomla wrote:

>I am trying to use GROUP BY cluse, what is the utility of this cluse in
MySQL
plz. any body tell me

That isn't really useful, however.

A real application would be, for example, "SELECT age FROM abc GROUP BY age",
which does the same job as "SELECT DISTINCT age ...", selecting only those ages
that are different.

Or "SELECT age,count(*) FROM abc GROUP BY age", which will count the records for
each value of age.

--
CB