下一个大于价值

本文介绍了下一个大于价值的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我想报告一辆车 有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