Arrange database Column entries by ascending order. Pin

[jeshra279]

Hi All, I have a SQL database column "ID", in which I added one by one entries as 2,5,6,1,8... randomely. I want to arrange these entries in Ascending order so that in datagridview it get displayed in order 1,2,3,4... like this. Can someone help me on this?

[Ashfield]

Ever tried the ORDER BY clause?

Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

[Niladri_Biswas]

Try this

declare @t table(id int)
insert into @t
select 3 union all
select 1 union all
select 5 union all
select 4 union all
select 2

Query:

select * from @t order by id

Output: id

1
2
3
4
5

:)

Niladri Biswas

[jeshra279]

I have already inserted "EmpID" as 1,2,3,4,5,6,7,8,9,10,11,12. But when i see the column data of table, i found that the data is arranged like this: 1 10 11 12 3 4 5 6 7 8 9 Since, the data is already inserted in the above order, i found that in crystal report the same format is coming...but i want the order in exactly ascending order in report finally, if not possible in database. Can someone help me on this?