| Forum: SQL |
Thema:
Count rows in query |
Von:
G. Guest (
20.09.2005 17:27) |
Hi
I have a table like this
NAME NUMBER
HANS 2
FRITZ 1
HANS 4
FRITZ 2
ULI 3
I am trying to get this:
HANS 2
FRITZ 2
ULI 1
So How often a person mentioned in the first row?
Can somebody please help
Thanx very much
Hannes
| Betreff |
Von |
Datum |
|
|
  |
Re: Count rows in query
| Hi, <br>try this:<br><br>select name, count(*) <br>from yourtablename <br>group by name<br><br>Greetz<br>Tom |
|
|
|
|
|
Thomas
Golla
|
20.09.2005 20:49 |
|
|
|
Antworten
Vorsicht bei der Eingabe: Die Zeichen ' oder -- sind nicht erlaubt!
