order by sort wrong records

Question

I have a table with `Subscription' , when I sort recordes with order by I getting wrong result . My Result Does not sort , by MyColumn

my query is :

Select Subscriptioncode from Subscription order by Subscriptioncode desc

my Result like as :

90
80
8
700
73
634
100

Why getting this Result ?

In SubscriptionCode some Row is Null.

100

Answer 1

Your column SubscriptionCode is currently not a numeric type, and it is likely a text type instead. However, you can CAST this column to an INT type and then the ordering should work with no problem:

Select Subscriptioncode from Subscription
order by CAST(Subscriptioncode AS INT) desc

Answer 2

You should declare Subscriptioncode column Datatype As INT

Example

create table Subscription(
Subscriptioncode  int)

insert into Subscription  values('90')
insert into Subscription  values('80')
insert into Subscription  values('8')
insert into Subscription  values('700')
insert into Subscription  values('73')
insert into Subscription  values('634')
insert into Subscription  values('100')


Select Subscriptioncode from Subscription order by Subscriptioncode desc

OUTPUT:

Subscriptioncode
700
634
100
90
80
73
8

Note:

As you are declaring datatype other than INT Ex:Varchar

-->It will sort values as like Sorting Alphabetical order i.e)abc

that's y you are getting wrong results.so choose correct Datatype.