Results of 1 - 1 of about 1 for temperature (0.001 sec.)
- SQL Introduction 9414
- This page provides an overview of how to perform simple operations in SQL. This tutorial is only intended to give you an introduction and is in no way a complete tutorial on SQL. This tutorial is adapted from the PostgreSQL tutorial . DuckD
...table name, along with all column names and their types: CREATE TABLE weather ( city VARCHAR, temp_lo INTEGER, -- minimum temperature on a day temp_hi INTEGER, -- maximum temperature on a day prcp FLOAT, date DATE ); You can enter this into the shell with...a column called city that is of type VARCHAR . VARCHAR specifies a data type that can store text of arbitrary length. The temperature fields are stored in an INTEGER type, a type that stores integer numbers (i.e., whole numbers without a decimal point). FL...ount , sum , avg (average), max (maximum) and min (minimum) over a set of rows. As an example, we can find the highest low-temperature reading anywhere with: SELECT max(temp_lo) FROM weather; max(temp_lo) 46 If we wanted to know what city (or cities) that r... - https://man.mtool.work/duckdb/2.0/sql/introduction.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work