请教一个简单的SQL语句

[weiyulin510037]

SELECT TexNames, COUNT(*) AS heji FROM SHManagers where TexJSUser = 'aaa'


请老师帮我修改一下, 我想在上面语句中加上 使用字段 heji 排序 可以吗???


SELECT TexNames, COUNT(*) AS heji FROM SHManagers where TexJSUser = 'aaa' GROUP BY heji

我这样写 在asp.net 中要报错

[秋的红果实]

SELECT TexNames, COUNT(*) AS heji FROM SHManagers where TexJSUser = 'aaa' order by heji ASC

[Jason_Mao1]

order by heji 或者 order by heji desc ，希望能帮助到你。

[秋的红果实]

我猜想你的意图是这样 测试用sql表

USE myDB
if object_id('SHManagers','U') is not null
  drop table SHManagers

GO

create table SHManagers(
  ID int identity(1,1) not null,
  TexNames nchar(10),
  TexJSUser nchar(10)
  )

GO

测试用数据 要实现的功能

select TexNames,count(*) as heji from SHManagers where TexJSUser='aaa' group by TexNames order by heji DESC

结果