TSQL:我想使用带有COUNT(*)AS'name'和ORDER BY'name'的SELECT语句 [英] TSQL: I want to use a SELECT statement with COUNT(*) AS 'name' and ORDER BY 'name'
问题描述
我是Transact-SQL编程的新手,并且没有编程背景,并希望有人可以指向我正确的方向。
方向。我有一个SELECT语句SELECT FIXID,COUNT(*)AS IOIs
并想要ORDER BY''IOI''''。我一直在梳理BOL,但是
我甚至不知道这会涉及到哪个主题/标题。
USE INDII >
SELECT FIXID,COUNT(*)AS IOI
FROM [dbo]。[IOI_2005_03_03]
GROUP BY FIXID
订购通过FIXID
我知道这是一个简单的问题,但也许有人可以协助
我。
谢谢,
I am very new to Transact-SQL programming and don''t have a programming
background and was hoping that someone could point me in the right
direction. I have a SELECT statement SELECT FIXID, COUNT(*) AS IOIs
and want to ORDER BY ''IOI''s''. I have been combing through the BOL, but
I don''t even know what topic/heading this would fall under.
USE INDII
SELECT FIXID, COUNT(*) AS IOIs
FROM [dbo].[IOI_2005_03_03]
GROUP BY FIXID
ORDER BY FIXID
I know that it is a simple question, but perhaps someone could assist
me.
Thanks,
推荐答案
尝试ORDER BY COUNT(*)而不是ORDER BY FIXID。
-Tom。
Try ORDER BY COUNT(*) instead of ORDER BY FIXID.
-Tom.
这封写的声明可能无法满足您的需求。
基本上它会返回表中的行数。那是'b $ b它。你想要点什么?
This statement as written may not give you what your looking for.
Basically its going to return the number of rows in your table. that''s
it. What are you trying to count?
汤姆,
我根据我对你的理解修改了我的查询建议例如
USE INDII
SELECT COUNT(*)AS IOI
来自[dbo]。[IOI_2005_03_03]
按计数排序(*)
以上示例有效,它返回所有IOI的总和。那将是
罚款,除了我试图看到每个的总IOI数量
''FIXID''按最大IOI数排序然后FIXID 。
Tom,
I modified my query as per my understanding of your suggestion e.g.
USE INDII
SELECT COUNT(*) AS IOIs
FROM [dbo].[IOI_2005_03_03]
ORDER BY COUNT(*)
The above example works, it returns a total of all IOIs. That would be
fine except that I am trying to see a total number of IOIs for each
''FIXID'' sorted by largest number of IOI''s then FIXID.
这篇关于TSQL:我想使用带有COUNT(*)AS'name'和ORDER BY'name'的SELECT语句的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!