tia ls - PowerPoint PPT Presentation

About This Presentation
Title:

tia ls

Description:

Title: No Slide Title Author: SIVALOGANATHAN Last modified by: Sivaloganathan Created Date: 2/25/2000 6:26:02 AM Document presentation format: On-screen Show (4:3) – PowerPoint PPT presentation

Number of Views:83
Avg rating:3.0/5.0
Slides: 17
Provided by: SIVA93
Category:
Tags: tia

less

Transcript and Presenter's Notes

Title: tia ls


1
SQL
tia lsõ t ,a
Pl install KELANI font if you cant read
2
fyd jevigykla ,shkakl ùug tla mßgtKl NdIdjla
mukla ok isàu mudKja fkdfõ
3
ta ksid fuu mdGud,dfõÈ wms mßgtKl NdId kla b.K
.kafkuq
4
1991 - 2008 olajd
ù î (wjqreÿ 17l muK merKs NdIdjla) VB
5
tia lsõ t,a (wjqreÿ 40l muK merKs NdIdjla) SQL
6
tlaia tï t,a (wjqreÿ -- l muK merKs
NdIdjla) wMa wkd.fha oa yqjudrefõ úm,ajhla
wes lr.k hk NdIdjls XML
7
wo wms b.kSug hkafka tia lsõ t,a SQL
8
tia lsõ t,a NdIdj ù î NdIdja MS-Access iuÕ Ndúd

9
SQL tia lsõ t,a NdIdj ù î NdIdj rï b.kSug myiq
fkdfõ
10
SQL tia lsõ t,a NdIdj Ndúd lrkafka úuiSï iyd
mukla fkdfõ
11
SQL 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
13
SQL tia lsõ t,aWod yrK
SELECT FROM Issues
SELECT Date,Code,Qty FROM IssuesDetails ORDER BY
Date
14
SQL tia lsõ t,aWod yrK
  • SELECT Code, Sum(Qty) AS SumOfQty
  • FROM IssuesDetails
  • GROUP BY Code ORDER BY Sum(Qty) DESC

15
Car Stock Control System
Engine SQL commands
16
End of Part II
Write a Comment
User Comments (0)
About PowerShow.com