Sql Groupby Multiple Columns(Sub Grouping) Help Plz

[dotnetrockz]

_{count(*) doesnt work either}

[ParmQ]

 

 

You are using it in aggregate function kadha? Using it in the aggregate function and using the same in the group by may not work.

[Silver_mani]

Baa, use partition by clause over Rank or row number.
 

Row no assign chesina kuda you have to group again on ur keys and Do the sum of the row no

[kranthi111]

select transactiondate,max(category),count(category) from #temp
group by transactiondate,category

idhi try chey

[ParmQ]

Row no assign chesina kuda you have to group again on ur keys and Do the sum of the row no

Yes, just partition by will not work.

[ParmQ]

select transactiondate,max(category),count(category) from #temp
group by transactiondate

idhi try chey

 

 

Adhi ela? you are not inserting anything into temp table. And you are not reading from an actual table.
 

[kranthi111]

Adhi ela? you are not inserting anything into temp table. And you are not reading from an actual table.
 

nenu sample ga rasanu script na DB lo.. temp table is main table akkada

[Silver_mani]

_{count(*) doesnt work either}

 

nenu check chesa mama ...it should work ...whats ur query ??
 

[ParmQ]

nenu sample ga rasanu script na DB lo.. temp table is main table akkada

 

Got it.
 

[ParmQ]

Final ga try this.

 

SELECT transactiondate, Category,   COUNT(*) as count
FROM Table
GROUP BY transactiondate, Category
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC

[pythonic]

_{count(*) doesnt work either}

 

intaki em db uncle....Oracle lo ayithe should work....is it mysql or sqlserver?

[quintin]

Bhaya china example hope this will work


Select a,b,c , d as count from (table name) group by a,b,c having count(*) > 1

[dkchinnari]

nenu check chesa mama ...it should work ...whats ur query ??
 

pls stop coming to DB..thanks for ur support  and understanding...

[quintin]

Final ga try this.

SELECT transactiondate, Category COUNT(*) count
FROM Table
GROUP BY transactiondate, Category
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC

correct

[Silver_mani]

Bhaya china example hope this will work


Select a,b,c , d as count from (table name) group by a,b,c having count(*) > 1

this is basically to check the no of duplicates on Keys .