COMPUTER LEARNING CENTER
WWW.HUUKHANG.COM
Select *
From tblOrders
Limit 0,10
Keát quaû traû veà nhö sau:
OrderID OrderDate CustID Amount
---------- --------------------------- -------
01
2001-09-05
10
2903576
02
2001-09-05
10
48168567
03
2001-09-05
10
5107032
04
2001-09-08
10
2.3555347
05
2001-09-08
16
1.81074847
06
2001-09-10
16
26000
07
2001-09-11
16
1867682
08
2001-09-12
16
3600000
09
2001-09-13
16
1.95713899
10
2001-09-14
16
9.61804228
Neáu muoán loïc ra 10 hôïp ñoàng coù soá tieàn nhieàu nhaát, baïn chæ caàn söû duïng saép xeáp theo coät
TotalAmount hay Amount trong baûng tblOrders.
Ví duï 8-13: Phaùt bieåu SQL daïng SELECT vôùi Limit N,M
Select OrderID,OrderDate,CustID,Amount
From tblOrders
Order by Amount Desc
Limit 0,10
Keát quaû traû veà nhö sau:
OrderID OrderDate CustID
Amount
---------- --------------------------- -------
06
2001-09-10 16
26000
26
2001-09-13 13
230000
25
2001-09-11 13
244904
23
2001-09-11 12
459162
31
2001-09-16 13
459525
27
2001-09-14 13
603033
28
2001-09-15 13
1452000
30
2001-09-15 13
1531200
07
2001-09-11 16
1867682
01
2001-09-05 10
2903576
Neáu muoán loïc ra 10 saûn phaåm coù soá löôïng baùn nhieàu nhaát, baïn chæ caàn söû duïng saép xeáp theo
coät soá löôïng Qtty.
Ví duï 8-14: Phaùt bieåu SQL daïng Select vôùi Limit N,M
Select ItemID,Qtty,Price,Amount
from tblOrderDetails
Where Amount>10
order by Qtty
Limit 0,10
Keát quaû traû veà nhö sau:
ItemID
Qtty Price Amount
---------------------------------------------
1
900
12000 12960000
Giaùo vieân: Phaïm Höõu Khang
