LẬP TRÌNH PHP CĂN BẢN - Trang 94

COMPUTER LEARNING CENTER

WWW.HUUKHANG.COM

/* > : lôùn hôn */

Select *

From

tblOrders

Where

Amount

>

100000;

/* < : nhoû hôn */

Select

*

From

tblOrders

Where

Amount

<

100000;

/* >= : lôùn hôn hoaëc baèng */

Select

*

From

tblOrders

Where

Amount

>=

100000;

/* >= : nhoû hôn hoaëc baèng */

Select

*

From

tblOrders

Where

Amount

<=

100000;


/* = : baèng */

Select

*

From

tblOrders

Where

CustID=‘12’;

/* != :Khaùùc */

Select

*

From

tblOrders

Where

CustID

!=‘12’;

/* <> : Khaùc */

Select

*

From

tblOrders

Where

CustID

<>‘12’;

/* !> : Khoâng lôùn hôn */

Select

*

From

tblOrders

Where

Amount

!>

100000;

/* !< : Khoâng nhoû hôn */

Select *

From

tblOrders

Where

Amount

!<

100000;


-- Caùc pheùp toaùn logic

/* and : Pheùp toaùn vaø */

Select

*

From

tblOrders

Giaùo vieân: Phaïm Höõu Khang