Count on column in SQL

See more:

SQL

database

data

When i try query data is like this


data from above query

VName	           (No column name)
				1
				1
				1
abc				1
abc				1
dfg				1
dfg				1
dfg				1
dfg				1
dfg				1
dfg				1
abc				1
abc				1
abc				1
dfg				1
abc				1
abc				1
DPSCB	     			1
MV				1
MV				1
MV				1
MV				1
MV				1
MV				1
MV				1

now i want data like this

What I have tried:

query which i tried
Select tblVV.ID,VName,COUNT(VName)
from tblVV
join tblRV on tblVV.MID = tblRV .ID
group by
VName,
tblVV.ID

how to get data this data

abc     7
dfg     7
DPSCB   1
MV      7
        3 (this is empty but i have to count this also )

columns in tblvv

ID MID VName Speed Name

columns in tblrv

ID FFID OName regno City

tblvv
ID     MID     VName     Speed Name
1	2	abc
2	3	abc
3	51	abc
4	67	
5	56	dfg
6	45	dfg
7	34	MV
8	24	MV <pre>

AND so on 
 
tblrv
<pre lang="SQL">
ID        FFID    OName  regno     City
1	106	Peter	AJ-29	  uk
2	105	Max	AVL-91	 US
3	104	John	AVL-995	 US
4	148	M Jon P	AVL-97	 uk
5	109	sAR	AM-713	 US
6	102	dAVID	ASJ-9	 uk <pre>