Pre-release documentation

This describes Beacon 2.0.0-rc3, a release candidate. Behavior documented here may still change before 2.0.0 ships, and some of it is not in any released build yet. For the current stable release, see the 1.8.0 documentation.

SELECT

Basic select

Name the columns that you need. Use * for all columns:

sql

SELECT time, latitude, longitude, temperature
FROM ocean_profiles

SELECT * FROM ocean_profiles LIMIT 100

Expressions and aliases

sql

SELECT
    time,
    latitude,
    longitude,
    temperature - 273.15 AS temperature_celsius,
    ROUND(salinity, 2)   AS salinity_psu
FROM ocean_profiles

ORDER BY

sql

SELECT time, latitude, longitude, temperature
FROM ocean_profiles
ORDER BY time DESC, latitude ASC

LIMIT and OFFSET

sql

SELECT * FROM ocean_profiles LIMIT 100

SELECT * FROM ocean_profiles LIMIT 100 OFFSET 200

DISTINCT

sql

SELECT DISTINCT platform_code FROM ocean_profiles

Quick Start

Getting Started

Datasets & Formats

Tables & Views

Guides

SELECT

Basic select

Expressions and aliases

ORDER BY

LIMIT and OFFSET

DISTINCT

SELECT ​

Basic select ​

Expressions and aliases ​

ORDER BY ​

LIMIT and OFFSET ​

DISTINCT ​

SELECT

Basic select

Expressions and aliases

ORDER BY

LIMIT and OFFSET

DISTINCT