Sorting by groups

Anon

I need to sort a table by groups of like data.

Would the correct syntax be:

SELECT * FROM table GROUP BY column

Thanks in advance.

Anon

No, select just the fields you want.

Anon

GROUP BY is a little different; it's used when you are using aggregate functions (e.g. MIN, COUNT, etc) and want a subtotal produced within like groups of data.
If all you want is the raw columns in a particular order, just use ORDER BY.
For example, to simply list the individual votes by state and county, say:

select state, county, votes from election order by state, city;

But if you want a subtotal for each state, say:

select state, sum(votes) from election group by state;

Anon

Two different responses... Let me see if I can explain a little better.

I have a table with information on 5 different states (statename, city). What I would like to do is query the database so that information gathered from the table appears in groups -- each group being based on statename.

The result might look like:

Foo, foosburgh
Foo, foostowne
Foo, foosville
Another State, alltownes
Another State, anytowne
Another State, sometowne

and so on...

Thanks,
Mike

Anon

It still depends on whether you need any totals/aggregates, or if you're just looking for the columns. Assuming the latter, it would be just:

select state, city, ... from table order by state, city;

Anon

If the table looks like

ID Name CountryID
1 A 3
2 b 2
3 D 3
4 E 1
5 R 3
6 S 2
7 H 3
8 U 1

How can I sort CountryID=2 in the result first?

My coding is
$result = mysql_query("select distinct Customer.ID, Customer.Name, Customer.CountryID".
"from Database where $cond order by Customer.ID, Customer.CountryID desc limit $offset,$limit" );

How to modify My Coding to make CountryID=2 in the result first (higher ranking)?