sql2005排序命令 [英] sql2005 sorting command

问题描述

我要选择我的表，该表根据表的日期时间字段排序..
从现在起最近的日期时间将首先显示..

请建议一些命令...

i want to select my table sorted according to datetime field of the table..
the nearest datetime from now will be displayed first..

pls suggest some command...

推荐答案

尝试:

SELECT * FROM myTable ORDER BY [date] DESC

使用 ORDER BY [ ^ ]

Use ORDER BY[^]

SELECT * FROM user ORDER BY name

这是您发布的快速basec sql问题，在问这里之前，您应该真的应该先买一本书或使用Google.如果您证明自己已尝试解决问题，则会获得更多帮助.

that''s to quick basec sql questions you''ve posted you should really get a book or use Google before asking here. You''ll get alot more help if you show you''ve tried to solve your problem yourself.

SQL ORDER BY Keyword

这篇关于sql2005排序命令的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！