Title: tia ls
1SQL
tia lsõ t ,a
Pl install KELANI font if you cant read
2fyd jevigykla ,shkakl ùug tla mßgtKl NdIdjla
mukla ok isàu mudKja fkdfõ
3ta ksid fuu mdGud,dfõÈ wms mßgtKl NdId kla b.K
.kafkuq
41991 - 2008 olajd
ù î (wjqreÿ 17l muK merKs NdIdjla) VB
5tia lsõ t,a (wjqreÿ 40l muK merKs NdIdjla) SQL
6tlaia tï t,a (wjqreÿ -- l muK merKs
NdIdjla) wMa wkd.fha oa yqjudrefõ úm,ajhla
wes lr.k hk NdIdjls XML
7wo wms b.kSug hkafka tia lsõ t,a SQL
8tia lsõ t,a NdIdj ù î NdIdja MS-Access iuÕ Ndúd
fõ
9SQL tia lsõ t,a NdIdj ù î NdIdj rï b.kSug myiq
fkdfõ
10SQL tia lsõ t,a NdIdj Ndúd lrkafka úuiSï iyd
mukla fkdfõ
11SQL tia lsõ t,a th oa moku iy j. iEug mdúÉÑ
lrhs
12 SQL tia lsõ t,a th oa we,a lsÍu, msltsfh,
lsÍu, úYaf,aYk lsÍu yd uld oóu lrhs
13SQL tia lsõ t,aWod yrK
SELECT FROM Issues
SELECT Date,Code,Qty FROM IssuesDetails ORDER BY
Date
14SQL tia lsõ t,aWod yrK
- SELECT Code, Sum(Qty) AS SumOfQty
- FROM IssuesDetails
- GROUP BY Code ORDER BY Sum(Qty) DESC
15Car Stock Control System
Engine SQL commands
16End of Part II