Task: Get sum of numeric field 'Price' from 'Goods' table.

Solution 1: Using Specialized Tool

  1. Open the database.
  2. Open the dataset, i.e. select a table 'Goods' from the table list or execute the following SQL query:
    SELECT Price FROM goods
  3. If you chose the table, switch to Data page.
  4. Double-click the 'Price' column. The program will start to do the aggregation. After it finished, you will see a set of calculated parameters from the column, including the sum.

Solution 2: Using SQL Aggregation

This is the most effective solution, especially for large tables.

  1. Open the database.
  2. Create new SQL window and type the following SQL text in the SQL editor:
    SELECT sum(price)
    FROM goods
  3. Click Execute Query button or press F9, and you will see a result with sum calculated.

See also

 Arithmetic Functions

 Working with SQL Queries