Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
atuljadhavnetafim
Starting Member
25 Posts |
 Posted - 2014-12-30 : 07:05:13
|
| Dear experti have table in sql and every month i am appending new data in this table, but i want to sort data Culumn Name "account_no' from smallest to largest, and whenever i append new data to this table it auto sort every time,please give solutionAtul Jadhav |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-12-30 : 09:35:24
|
| When you query the table, use an ORDER BY clause:SELECT ...FROM ...ORDER BY account_no |
 |
|
|
|
|
|
Sort Data table Smalles to largest