如何在sql server 2005中按日期排序行？ [英] How to Sorting rows in date wise in sql server 2005?

问题描述

I want to sort multiple rows in date wise in sql server 2005..

First I create a table "StuInfo" and two attributes StuName, AdmissionDate their datatype are varchar2(20).

create database ForTest;
create table StuInfo(Roll int, StuName varchar(50), AdmissionDate varchar(20));
insert into StuInfo values(10,'Ram Das','10-May-2014');
insert into StuInfo values(15,'Shyam Das','09-Apr-2014');
insert into StuInfo values(18,'Jadu Das','05-May-2014');
insert into StuInfo values(12,'Madhu Das','02-May-2014');
insert into StuInfo values(14,'Rabi Das','22-Jun-2014');
insert into StuInfo values(20,'Rabin Das','10-May-2014');

插入后我尝试按日期顺序对插入的行进行排序。



命令是：



选择*来自StuInfo订单的AdmissionDate desc;



但是没有正确排序....



我想要排序....派遣/下达订单即（订单）：



AdmissionDate



09-Apr-2014

02-May-2014

05-May-2014

10-May-2014

10-May-2014

22-Jun-2014



请帮助我。

After Insert I try to sort inserted rows in date wise with assending order.

command is:

select *from StuInfo order by AdmissionDate desc;

but does not sorting properly....

I want to sort.... assending/desending order that is (assending order):

AdmissionDate

09-Apr-2014
02-May-2014
05-May-2014
10-May-2014
10-May-2014
22-Jun-2014

Please Help me.

推荐答案

你的数据es应该是日期类型不是 varchar ，更改它并且你有排序功能。

Your dates should be a Date type not varchar, change it and you have sort capability.

检查一下：如何排序 - varchar-date-in-sql-server [ ^ ]。请注意解决方案结束时的建议。

Check this out: how-to-sort-varchar-date-in-sql-server[^]. Note the advice at the end of the solution.

试试这个.. :)

try this.. :)

with samp as(

select *,convert(date,AdmissionDate)as AdmDate from StuInfo

)
select * from samp order by AdmDate desc

这篇关于如何在sql server 2005中按日期排序行？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！