Wolfram Language & System 10.4 (2016)|Legacy Documentation

This is documentation for an earlier version of the Wolfram Language.View current documentation (Version 11.2)

Database-Like Operations on Datasets

Wolfram Language Dataset objects allow arbitrary hierarchical data on which a rich set of possible operations can be applied. Dataset objects can also directly represent traditional relational databases, on which Wolfram Language functions can be used to perform traditional SQL-like operations.

ReferenceReference

Select SQL WHERE

GroupBy SQL GROUP BY

Counts, CountsBy SQL COUNT

Insert, Append SQL INSERT

Delete, Drop SQL DELETE

DeleteDuplicates SQL UNIQUE

Union, Catenate, Merge SQL UNION

JoinAcross SQL JOIN