谁能帮我写这样的SQL语句? 谢谢啦

来源：百度知道 编辑：UC知道 时间：2024/05/15 05:38:23
有一个表:内容如下:
"ID" "Bcontent" "Btixingtime" "Bflag" "Binputtime"
4 "asdf" "2007-5-7" "未" 2007-5-21 21:12:52
5 "asf" "2007-5-21" "未" 2007-5-21 21:19:20
6 "asdfasdf" "2007-5-8" "未" 2007-5-22 10:25:29
8 "测试吃水" "2007-6-7" "未" 2007-6-7 16:02:44
10 "测试此功能" "2007-6-19" "未" 2007-6-18 16:02:45
11 "再来一次" "2007-6-23" "未" 2007-6-18 16:07:47
我想用SQL语句查询这样的结果:
"ID" "内容" "提醒时间" "标志" "Binputtime"
8 "测试吃水" "2007-6-7" "未" 2007-6-7 16:02:44
10 "测试此功能" "2007-6-19" "未" 2007-6-18 16:02:45
11 "再来一次" "2007-6-23" "未" 2007-6-18 16:07:47
6 "asdfasdf" "2007-5-8" "未

假设你的当前时间是 @date (如果要当前系统时间就改为GetDate())
只要加一个order by 就可以
order by abs(datediff(ss,Binputtime,@date)) asc

select ID ,Bcontent as 内容,Btixingtime as 提醒时间,Bflag as 标志,Binputtime from 表名 order by Binputtime DESC

select * from 表 order by Binputtime asc
或者
select * from 表 order by Binputtime desc

asc意思升序
desc意思倒序

你把表按时间排序就可以

.....