MS sql查询问题 [英] MS sql Query problem

问题描述

我对选择查询有一个非常简单的问题。我的表有列ID和名称

< TR>

ID	名称
1	ABC
1	ABC
1	XZE
1	QWE
2	XYZ
2	ADF
1	jkl

我想显示带有> = 4的ID还有。

i have a very simple problem with select query . I Have table having Column id and name

ID	Name
1	abc
1	abc
1	xze
1	qwe
2	xyz
2	adf
1	jkl

i want to show id having >=4 with there name also.

select name ,id ,COUNT(id) from demo group by id ,name  having COUNT(id)>=4

查询正在执行完美但不返回任何内容。它显示空行。为什么？？

the query is executing perfectly but does not return anything .It shows Empty Rows. WHY??

推荐答案

你好，



我怀疑你想做什么

Hi there,

I suspect you want to do

SELECT ID, COUNT(Name) HAVING COUNT(NAME) > 4 

尝试：

Try:

SELECT 
  name ,id 
FROM
  demo 
GROUP BY
  id
HAVING 
  COUNT(id) >= 4

您好，



试试这个脚本....

Hi,

Try this script....

SELECT DISTINCT M.Id, M.Name, T.IDsCount 
FROM demo M
INNER JOIN (SELECT id, COUNT(id) 'IDsCount' 
			FROM demo 
			GROUP BY id
			HAVING COUNT(id) >= 4) T ON T.IDsCount=M.id

问候，

GVPrabu

Regards,
GVPrabu

这篇关于MS sql查询问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！