本文介绍了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
更多推荐
sql2005排序命令
发布评论