table 表 类型 注释
id 自动增长
year 数字 年
month 数字 月
添加:
insert into table(year,month) values(1988,1)
insert into table(year,month)values(1989,2)
insert into table(year,month)values(1990,3)
insert into table(year,month)values(1991,4)
insert into table(year,month)values(1992,5)
insert into table(year,month)values(1993,6)
insert into table(year,month)values(1994,7)
insert into table(year,month)values(1995,8)
insert into table(year,month)values(1986,9)
1.自定义排序查询(根据year排序):
select *from table order by iif(year=1989,1,iif(year=1988,2,iif(year=1992,3,iif(year=1991,4,5))))
2.自定义排序查询(根据month排序):
select *from table order by iif(month=9,1,iif(month=8,2,iif(month=6,3,iif(month=2,4,5))))
3.自定义排序查询(根据year,month排序):
select *from table order by iif(year=1989,1,iif(year=1988,2,iif(year=1992,3,iif(year=1991,4,5)))),
iif(month=9,1,iif(month=8,2,iif(month=6,3,iif(month=2,4,5))))