Home > database >  SQL query curriculum
SQL query curriculum

Time:10-28

Schedule table Schedule
Start date StartDate 2019-02-02
End date EndDate
9999-12-12Class: every

Class schedule ScheduleTime
The curriculum ID: ScheduleId
Class time: StartTime 13:00
Class is over time: the endTime 14:00
A few class: Weekly 2

I want to check a time period all curriculum zha zha?? O great god teach


Note: the records the curriculum effective time, time table is to record a week a few points adding and dropping classes,

I need to check out the 2022-1-1 to 2022-1-1 which day have class,,,
The output of hope:

A class date week of class time to work a few class

CodePudding user response:

Build good test data sent to questions easy to answer
  • Related