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
