TSQL：我想使用带有COUNT（*）AS'name'和ORDER BY'name'的SELECT语句

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 programmingbackground and was hoping that someone could point me in the rightdirection. I have a SELECT statement SELECT FIXID, COUNT(*) AS IOIsand want to ORDER BY ''IOI''s''. I have been combing through the BOL, butI don''t even know what topic/heading this would fall under. USE INDIISELECT FIXID, COUNT(*) AS IOIsFROM[dbo].[IOI_2005_03_03]GROUP BY FIXIDORDER BY FIXID I know that it is a simple question, but perhaps someone could assistme. 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''sit. 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 INDIISELECT COUNT(*) AS IOIsFROM[dbo].[IOI_2005_03_03]ORDER BY COUNT(*) The above example works, it returns a total of all IOIs. That would befine 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语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！