(SELECT 车次 FROM table Where 到点 >'02:00:00' order by 到点 asc) union all (select 车次 From table where 到点 <'02:00:00' order by 到点 desc)
改:(SELECT 车次 FROM table Where 到点>'02:00:00' Group by 到点) union all (select 车次 From table where 到点<'02:00:00' Group by 到点)
(SELECT 车次 FROM table Where 到点 >now() order by 到点 asc) union all (select 车次 From table where 到点 <now() order by 到点 desc)无法实现。请继续指导!
(SELECT 车次 FROM table Where 到点>CONVERT(varchar(100), now(), 24) Group by 到点) union all (select 车次 From table where 到点<CONVERT(varchar(100), now(), 24) Group by 到点)
SELECT 车次 FROM 表名 ORDER BY Date()+到点-((Date()+到点)<Now())
我用的是ACCESS数据库,报convert没有定义
(SELECT 车次 FROM table Where 到点>format(now, "hh:mm") Group by 到点) union all (select 车次 From table where 到点<format(now, "hh:mm") Group by 到点)
(SELECT 车次 FROM table Where 到点>format(now, "hh:mm") Group by 到点) union all (select 车次 From table where 到点<format(now, "hh:mm") Group by 到点) 试图执行的查询中不包含作为合计函数一部分的特定表达式“车次”
(SELECT 车次 FROM table Where 到点>format(now, "hh:mm") Group by 到点,车次) union all (select 车次 From table where 到点<format(now, "hh:mm") Group by 到点,车次)
(SELECT 车次 FROM table Where 到点
>'02:00:00' order by 到点 asc)
union all
(select 车次 From table where 到点
<'02:00:00' order by 到点 desc)
union all
(select 车次 From table where 到点<'02:00:00' Group by 到点)
>now() order by 到点 asc)
union all
(select 车次 From table where 到点
<now() order by 到点 desc)无法实现。请继续指导!
union all
(select 车次 From table where 到点<CONVERT(varchar(100), now(), 24) Group by 到点)
SELECT 车次
FROM 表名
ORDER BY Date()+到点-((Date()+到点)<Now())
(SELECT 车次 FROM table Where 到点>format(now, "hh:mm") Group by 到点)
union all
(select 车次 From table where 到点<format(now, "hh:mm") Group by 到点)
union all
(select 车次 From table where 到点<format(now, "hh:mm") Group by 到点)
试图执行的查询中不包含作为合计函数一部分的特定表达式“车次”
(SELECT 车次 FROM table Where 到点>format(now, "hh:mm") Group by 到点,车次)
union all
(select 车次 From table where 到点<format(now, "hh:mm") Group by 到点,车次)