My Table Consist with ID,Location,Image,Title,IsValid Columns. I want Count of IDs,Location,Image from that table
How can i write this query ? Like
Select Count(ID),Location,Image
from Table_Name
Where IsValid=1
Group By Location,Image
But i didnt get exact o/p,i hope you understand my probelm.