Daita
  • Introduction
  • Getting started
  • Usage
    • relational
      • SELECT
      • INSERT
      • UPDATE
      • DELETE
      • Schema
        • CREATE SCHEMA
      • Table
        • CREATE TABLE
        • ALTER TABLE
        • DROP TABLE
        • LOCK TABLE
      • View
        • CREATE VIEW
        • DROP VIEW
      • Index
        • CREATE INDEX
        • DROP INDEX
      • Functions
        • Aggregation
          • AVG
          • COUNT
          • MAX
          • MIN
          • SUM
        • Conditional
          • CASE WHEN
          • COALESCE
          • GREATEST
          • LEAST
        • Date
          • DAY OF MONTH
          • DAY OF WEEK
          • DAY OF YEAR
          • HOUR
          • MINUTE
          • MONTH
          • NOW
          • SECOND
          • WEEK OF YEAR
          • YEAR
        • Numeric
          • CEIL
          • FLOOR
          • ROUND
        • String
          • CONCAT
    • ORM
    • cli
  • Adapters
    • pg-adapter
    • sqlite-adpater
    • mariadb-adpater
    • http-adpater
Powered by GitBook
On this page
  1. Usage
  2. relational
  3. Functions
  4. Aggregation

SUM

const stats = await client.select({
   select: {
       height: sum(Moutain, 'height'),
       country: field(Mountain, 'country'),
   }
   from: table(Mountain),
   groupBy: field(Mountain, 'country'),
});
// sql: SELECT sum("Mountain"."height"), "Mountain"."country"
//      FROM "Mountain"
//      GROUP BY "Mountain"."country"
//
// const stats: { height: number, country: string }[]
PreviousMINNextConditional

Last updated 1 year ago