如图这张数据表中,我用如下sql语句查询列车信息
select trainNum, type, arriveTime, startDriveTime,km
from train_091203
where station like '常州' and trainNum in (select trainNum from train_091203 where station='无锡')
现在遇到的问题是查出的两个站点之间的公里数km有问题,也就是只能查处死板的数据,不知如何对数据进行操作?请高人帮忙完善一下sql语句,多谢!这是使用到的列车信息数据库
from train_091203 A Join (select * from train_091203 where station='无锡')B
On A.trainNum=B.trainNum where A.station = '常州' Group by A.trainNum
给出你的测试数据
给出你要的结果示例。
from train_091203 a Inner Join train_091203 b on a.trainNum=b.trainNum
Where a.station='常州' and b.station='无锡'