Funguo ya SUM() ya SQL
- Mwanzo wa juzi SQL min()
- Pya zaidi SQL Group By
Fomu ya SUM()
Fomu ya SUM inaonyesha jumla ya barua ya namba (jumla).
Inayotumika kwa kusoma SQL SUM()
SELECT SUM(jina la kolumu) FROM jina la tablica
Mfano wa SQL SUM()
Tunahifadhiwa tablica ya 'Orders' hii:
| O_Id | OrderDate | OrderPrice | Customer |
|---|---|---|---|
| 1 | 2008/12/29 | 1000 | Bush |
| 2 | 2008/11/23 | 1600 | Carter |
| 3 | 2008/10/05 | 700 | Bush |
| 4 | 2008/09/28 | 300 | Bush |
| 5 | 2008/08/06 | 2000 | Adams |
| 6 | 2008/07/21 | 100 | Carter |
Sasa, tunataka kutafuta jumla ya 'OrderPrice' kwa sababu ya kina.
Tunatumia matendo ya SQL yafuatayo:
SELECT SUM(OrderPrice) AS OrderTotal FROM Orders
Matokeo ya muhimu inaonekana kama hii:
| OrderTotal |
|---|
| 5700 |
- Mwanzo wa juzi SQL min()
- Pya zaidi SQL Group By
