依靠SQL中的列 [英] Count on column in SQL

问题描述

当我尝试查询数据时是这样的





来自上述查询的数据

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

现在我想要这样的数据



我是什么尝试过：



我试过的查询

选择tblVV.ID，VName，COUNT（VName）

来自tblVV

加入tblRV on tblVV.MID = tblRV .ID

group by

VName，

tblVV.ID



如何获取此数据的数据

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 )

列中的tblvv



ID MID VName速度名称



tblrv中的列



ID FFID OName regno City

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>

推荐答案

您的问题是您在GROUP BY中包含了 ID 。 br />
尝试

Your problem is that you have included ID in the GROUP BY.
Try

Select VName,COUNT(VName) 
from tblVV
join tblRV on tblVV.MID = tblRV.ID
group by VName
ORDER BY ISNULL(VName, 'zzzz')

ORDER BY上的isnull位只是为了获取最后的空条目

The isnull bit on the ORDER BY is just to get the null entry last

这篇关于依靠SQL中的列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！