sql2005排序命令

本文介绍了sql2005排序命令的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

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

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关键字 SQL ORDER BY Keyword