listview and sql

[ozgurdunya]

i want to show total counts of records in listview with sql

the records

column1 ,column2
row1 record1 1
row2 record1 2
row3 record1 3
row4 record1 4
row5 record1 5
row6 record2 1
row7 record2 2
row8 record2 3


will be shown like this :

column1 , column2
row1 record1 5
row2 record2 3

is it possible ?

[LaVolpe]

Welcome to the forums

Easy enough. Build your SQL statement to use GROUP BY statement and a count. In your example, it would return just 2 records, one with a count of 5 and another with a count of 3. Transfering those returned records to a listview is easy enough

If you are having problems with your SQL statement, you may want to post that. If you are not familiar with a listview, search the forum for example usage

[ozgurdunya]

thanks i solved by using "group by" and "having count"