我怎么能这样做我根据自己的意愿得不到数据 [英] How Can I Do This I Am Not Getting The Data According To My Wish

查看:82
本文介绍了我怎么能这样做我根据自己的意愿得不到数据的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有数据,其中记录按DATE_排序我想根据日期显示数据问题是我想根据日期显示数据,如01/03/2014之后我想要那个28 / 02/2014

,但数据将在2014年2月2日之后发布。

我必须在此行中做出哪些更改

i have data where the records are sorted by DATE_ i want to display the data on the basis of date the problem is that i want to display the data according to date like 01/03/2014 after that i want that 28/02/2014
but the data is coming as 01/03/2014 after that 02/02/2014.
what changes i have to make in this line

Quote:

AutoGenerateColumns =FalseDataSourceID =SqlDataSource1PageSize =30Type =integer>

AutoGenerateColumns="False" DataSourceID="SqlDataSource1" PageSize="30" Type="integer">







引用:

Morning Super Delux下午Dimand Moti金银晚会快递之夜_

62 41 01/03/2014

25 39 98 35 06 22 17 49 76 61 11 02/02/2014

48 84 26 69 11 02 27 73 94 80 81 03/02/2014

09 23 37 88 76 34 34 50 91 15 20 04/02/2014

52 25 77 00 94 31 17 52 82 37 77 05/02/2014

63 27 56 47 11 20 98 52 00 64 03 06/0 2/2014

14 91 46 58 79 26 99 35 41 08 63 07/02/2014

70 00 02 64 49 57 35 11 59 47 41 08/02 / 02 / 2014

54 54 70 83 11 89 85 68 06 00 00 09/02/2014

19 07 16 00 99 83 15 20 04 69 00 10/02/2014

85 51 05 56 77 26 92 44 18 23 33 11/02/2014

41 74 03 11 77 94 42 57 67 48 20 12/02/2014

98 87 28 19 94 66 42 57 81 97 75 13/02/2014

11 22 97 36 30 72 24 75 02 82 67 14/02/2014

44 09 16 22 10 66 12 27 56 11 75 15/02/2014

59 90 85 60 71 49 24 72 33 89 00 16/02/2014

86 11 89 44 00 94 74 97 06 88 35 17/02/2014

18 84 29 44 17 08 34 59 93 65 53 18/02/2014

61 05 29 17 87 15 70 60 56 35 94 19/02/2014

78 42 98 79 99 31 26 16 65 43 13 20/02/2014

05 92 37 79 66 10 59 33 21 71 31 21/02/2014

14 94 15 77 59 15 43 48 27 96 96 22/02/2014

11 72 51 84 22 78 95 22 74 04 10 23/02/2014

11 98 66 31 37 33 95 09 91 45 28 24/02/2014

31 77 76 78 69 28 33 05 00 98 31 25/02/2014

42 25 12 78 93 98 59 00 63 81 67 26/02/2014

26 72 61 05 59 03 65 73 65 44 04 27/02/2014

00 48 11 51 03 04 15 25 91 05 11 28/02/2014

Morning Super Delux Afternoon Dimand Moti Gold Silver Evening Express Night Date_
62 41 01/03/2014
25 39 98 35 06 22 17 49 76 61 11 02/02/2014
48 84 26 69 11 02 27 73 94 80 81 03/02/2014
09 23 37 88 76 34 34 50 91 15 20 04/02/2014
52 25 77 00 94 31 17 52 82 37 77 05/02/2014
63 27 56 47 11 20 98 52 00 64 03 06/02/2014
14 91 46 58 79 26 99 35 41 08 63 07/02/2014
70 00 02 64 49 57 35 11 59 47 41 08/02/2014
78 54 70 83 11 89 85 68 06 00 00 09/02/2014
19 07 16 00 99 83 15 20 04 69 00 10/02/2014
85 51 05 56 77 26 92 44 18 23 33 11/02/2014
41 74 03 11 77 94 42 57 67 48 20 12/02/2014
98 87 28 19 94 66 42 57 81 97 75 13/02/2014
11 22 97 36 30 72 24 75 02 82 67 14/02/2014
44 09 16 22 10 66 12 27 56 11 75 15/02/2014
59 90 85 60 71 49 24 72 33 89 00 16/02/2014
86 11 89 44 00 94 74 97 06 88 35 17/02/2014
18 84 29 44 17 08 34 59 93 65 53 18/02/2014
61 05 29 17 87 15 70 60 56 35 94 19/02/2014
78 42 98 79 99 31 26 16 65 43 13 20/02/2014
05 92 37 79 66 10 59 33 21 71 31 21/02/2014
14 94 15 77 59 15 43 48 27 96 96 22/02/2014
11 72 51 84 22 78 95 22 74 04 10 23/02/2014
11 98 66 31 37 33 95 09 91 45 28 24/02/2014
31 77 76 78 69 28 33 05 00 98 31 25/02/2014
42 25 12 78 93 98 59 00 63 81 67 26/02/2014
26 72 61 05 59 03 65 73 65 44 04 27/02/2014
00 48 11 51 03 04 15 25 91 05 11 28/02/2014

推荐答案

SELECT * FROM table ORDER BY timestamp DESC







试试看.. :)




try it out..:)


这篇关于我怎么能这样做我根据自己的意愿得不到数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆