下一个大于价值 [英] Next Greater than Value
问题描述
我想报告一辆车
有2张桌子
1)车辆
2)车辆时刻表>
1)车辆
COlUMN 1 |第2栏
车辆代码| VEHICLE-KM
0000000001 | 1000
0000000002 | 2000
0000000003 | 5000
0000000004 | 8000
2)车辆时间表
COlUMN 1 |第2栏
id |车辆 - 时间表 - 重新开始
01 | 2000
02 | 5000
03 | 8000
04 | 12000
这两张桌子
但我需要加入其中Vehile,Colum1和VehicleScdule Colum2 Max值
例子
3)车辆加入
COlUMN 1 |第2栏
车辆代码| VEHICLE-KM |车辆 - 时间表 - 重新开始
0000000001 | 1000 | 2000
0000000002 | 2000年| 5000
0000000003 | 5000 | 8000
0000000004 | 8000 | 12000
我如何选择Next大于车辆时间表中的值
i Want to make Report about A vehicle
there is 2 table
1) Vehicle
2) Vehicle-schedule
1) Vehicle
COlUMN 1 | COLUMN 2
Vehicle-Code | VEHICLE-KM
0000000001 | 1000
0000000002 | 2000
0000000003 | 5000
0000000004 | 8000
2) Vehicle-schedule
COlUMN 1 | COLUMN 2
id | VEHICLE-SCHEDULE-FOR-REVISIT
01 | 2000
02 | 5000
03 | 8000
04 | 12000
These two tables
but i need join where Vehile,Colum1 and VehicleScdule Colum2 Max value
Example
3) Vehicle-join
COlUMN 1 | COLUMN 2
Vehicle-Code | VEHICLE-KM | VEHICLE-SCHEDULE-FOR-REVISIT
0000000001 | 1000 | 2000
0000000002 | 2000 | 5000
0000000003 | 5000 | 8000
0000000004 | 8000 | 12000
how I select Next Greater than value from Vehicle Schedule table
推荐答案
SELECT v.[Vehicle-Code], v.[VEHICLE-KM],
(
SELECT MIN(s.[VEHICLE-SCHEDULE-FOR-REVISIT]) FROM [Vehicle-Schedule] s
WHERE s.[VEHICLE-SCHEDULE-FOR-REVISIT] > v.[VEHICLE-KM]
) AS [VEHICLE-SCHEDULE-FOR-REVISIT]
FROM Vehicle v
这两个表应该有关系,
例如,你可以添加一列表1或表2,生病使用表2
1.在表2上添加Vechicle-Code列。
2.然后我'我会在桌子上分配相同的代码1
3.继承人查询
Sele ct table1.Vehicle-Code,table1.Vehicle-km,table2.VEHICLE-SCHEDULE-FOR-REVISIT from table1,table2 where table1.VehicleCode = table2.VehicleCode
希望这有帮助,
Elieser Legaspi
Hi,
Those two tables should have relation,
For example, you can add one column on table 1 or table 2, ill use table 2
1. Ill add Vechicle-Code column on table2.
2. Then i'll assign its same code on the table 1
3. heres the query
"Select table1.Vehicle-Code, table1.Vehicle-km,table2.VEHICLE-SCHEDULE-FOR-REVISIT from table1, table2 where table1.VehicleCode = table2.VehicleCode"
Hope this helps,
Elieser Legaspi
这篇关于下一个大于价值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!