General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>
>Edgar,
>I'm not sure I understood it. Would you get something like :
>
>0 = 30+55...
>1 = 24+10... ?
>
Cetin
0-1 would be the column, namely Values, that would identify the values I'm counting. I don't have that. Therefore, I need a way to create that column so I can identify each COUNT.
In other words, if I had only one column I need to count, I would do
SELECT fld1 AS values,COUNT(Fld1) total FROM nTable
that would show:
0....39
1....40
2....55
3....90
4....29
5....4
but like I said, I have 30+ fields that I need to do this.
Let me know if I didnt explained mayself again
thanks Celtin
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only