按sql查询排序，不按顺序显示 [英] order by sql query , not displaying in order

问题描述

我想显示如下记录:

sr没有年龄分布
0 0 254
1 1 125
2 2 45
3 3 47
4 4 24

这是我正在使用的查询，但未按顺序显示，其序列为1,10,100,2,20,21,22,23

SELECT Age，COUNT(PID)AS [年龄分布]
FROM [主数据]按年龄分组或按年龄分组asc

i want to display records as follow:

sr no Age Distribution
0 0 254
1 1 125
2 2 45
3 3 47
4 4 24

this is the query i am using, but it is not displaying in series, its series is 1,10,100,2,20,21,22,23

SELECT Age,COUNT(PID)AS [Age wise Distribution]
FROM [Main Data]GROUP BY Age ORDER BY Age asc

推荐答案

年龄的数据类型是什么?
我猜您已将其分配为nvarchar. 将其设为整数.
根据nvarchar数据类型，您将获得正确的结果.

What is the datatype of Age?
I guess you have assigned it as nvarchar. Make it integer.
According to nvarchar datatype, you are getting correct result.

这篇关于按sql查询排序，不按顺序显示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！