当前位置: 动力学知识库 > 问答 > 编程问答 >

Select max in SQL Server 2008 R2 using C#

问题描述:

This question already has an answer here:

  • GROUP BY / aggregate function confusion in SQL

    3 answers

网友答案:

In SQL server this is not allowed, since you're asking for fields that are not contained in the GROUP BY clause or in an aggregate function, like MAX. The only way is to put all of the requested fields in the GROUP BY clause

分享给朋友:
您可能感兴趣的文章:
随机阅读: