COMPUTER LEARNING CENTER
WWW.HUUKHANG.COM
Where
Amount
!>100000
And
CustID=‘12’;
/* Or : Pheùp toaùn hoaëc */
Select
*
From
tblOrders
Where
Amount
!>100000
Or
CustID=‘12’;
/* Not : Pheùp toaùn phuû ñònh */
Select
*
From
tblOrders
Where
OrderDate
is
NOT
NULL;
/* Between: giaù trò naèm trong mieàn */
Select
*
From
tblOrders
Where
Amount
Between 10 and 500;
/* Like : Pheùp toaùn so saùnh gaàn gioáng, söû duïng daáu %
ñeå theå hieän thay theá baát kyø kyù töï */
Select
*
From
tblOrders
Where
Descriion
like
'%A'
Or
CustID
='152';
/* Not Like : Pheùp toaùn phuû ñònh so saùnh gaàn gioáng,
söû duïng daáu % ñeå theå hieän thay theá baát kyø kyù töï */
Select
*
From
tblOrders
Where
Descriion
not
like
'%A'
Or
CustID
='152';
/* IN : Pheùp toaùn so saùnh trong moät taäp hôïp */
Select *
From tblOrders
Where OrderID in ('134','244','433');
/* Not IN : Pheùp toaùn phuû ñònh so saùnh trong moät taäp hôïp */
Select *
From tblOrders
Where OrderID not in ('134','244','433');
Giaùo vieân: Phaïm Höõu Khang
