条件选择WHERE/IF 关键词:
以前的版本用到IF比较多,现在主要都用WHERE,其实两个命令是一样的,只是在限制与写法上略微有些不同。
IF的结果:
| ||||
COUNTRY | CAR | MODEL | SEATS | |
ENGLAND | JAGUAR | V12XKE AUTO | 2 | |
JAGUAR | XJ12L AUTO | 5 | ||
JENSEN | INTERCEPTOR III | 4 | ||
TRIUMPH | TR7 | 2 | ||
JAPAN | DATSUN | B210 2 DOOR AUTO | 4 | |
TOYOTA | COROLLA 4 DOOR DIX AUTO | 4 |
WHERE的结果:
| ||||
COUNTRY | CAR | MODEL | SEATS | |
ENGLAND | JAGUAR | XJ12L AUTO | 5 | |
JENSEN | INTERCEPTOR III | 4 | ||
ITALY | ALFA ROMEO | 2000 4 DOOR BERLINA | 4 | |
JAPAN | DATSUN | B210 2 DOOR AUTO | 4 | |
TOYOTA | COROLLA 4 DOOR DIX AUTO | 4 |
还有一种WHERE的使用方法:
用到IN FILE的结果:
| ||
COUNTRY | CAR | |
ENGLAND | JAGUAR | |
JENSEN | ||
TRIUMPH | ||
ITALY | ALFA ROMEO | |
MASERATI | ||
JAPAN | DATSUN | |
TOYOTA |