query.sql

用C#编写的实现火车查询功能的程序功能比较完整

select * from T_schedule
select * from T_schedule_detail

--查询两个站点间的直达车
select *
from T_schedule
where schedulecode in(
			select schedulecode
			from  T_schedule_detail ta
			where cityname='到达站' and schedulecode in(
								select schedulecode
								from  T_schedule_detail tb
								where cityname='出发站' and ta.numofschedule>tb.numofschedule))

--查询中转站
select distinct cityname
from  T_schedule_detail
where schedulecode in(
			select schedulecode
			from  T_schedule_detail
			where cityname='保定') and cityname<>'保定' and cityname in(
select distinct cityname
from  T_schedule_detail
where schedulecode in(
			select schedulecode
			from  T_schedule_detail
			where cityname='海南') and cityname<>'海南')