|
最佳回答 |
|
0
|
snrtuemcLv8专家互助发布于2023-2-14 14:32
|
SELECT TOP (10000000) [ryid] ,[ryxm] ,min([dlsj])as[dlsj] ,max([tcsj])[tcsj] FROM testS where [dlsj] between '${开始日期控件名}' and '${结束日期控件名}' group by ryid,ryxm order by dlsj desc |
|
|
|
|
最佳回答 |
|
0
|
用户6NWif5139660Lv6资深互助发布于2023-2-14 14:33
|
SELECT TOP (10000000) [ryid] ,[ryxm] ,min([dlsj])as[dlsj] ,max([tcsj])[tcsj] FROM testS where [dlsj] between '${开始时间}' and '${结束时间}' group by ryid,ryxm order by dlsj desc |
|
|
|
|
最佳回答 |
|
0
|
Z4u3z1Lv6专家互助发布于2023-2-14 14:33
|
SELECT TOP (10000000) [ryid] ,[ryxm] ,min([dlsj])as[dlsj] ,max([tcsj])[tcsj] FROM testS where [dlsj] between '${开始日期}' and '${结束日期}' group by ryid,ryxm order by dlsj desc |
|
|
|
1min目标场景问卷
立即参与
