# Examples

# Selecting Columns

• All Columns
• Defined Columns
• All Series Tags
• Text Value Column
• Metadata Columns
• Entity Tag Columns
• Metric Tag Columns
• Entity Metadata
• Column Alias
• Escape Quotes
• Interval Number

# Selecting Tables

• Table Alias
• atsd_series Table

# Modifying Columns

• Date Format
• Date Extract Functions
• Date Utility Functions
• Computed Columns
• Mathematical Functions
• String Functions
• LOOKUP Function
• CASE Expression

# Filtering Records

• Filter by Date
• Filter by Series Tag
• Filter by NULL Series Tag
• Filter by Series Tag with Comparison Operators
• Filter by Entity
• Filter by Entity Tag
• Filter by Entity Group
• Filter Not-a-Number
• Limit Row Count
• Limit by Partition

# Ordering Records

• Order By Time
• Order By Value
• Order By Multiple Columns
• String Collation

# Aggregation

• Average Value
• Percentiles
• First/Last
• Counter Aggregator
• Maximum Value Time
• Period Aggregation
• Recent Values Aggregation

# Grouping

• Group by Query with Order By
• Grouped Average
• Group by Tags
• Group with Having
• Grouped and Having

# Interpolation

• Interpolate
• Interpolate with Extend
• Interpolate Edges

# Regularization

• Linear Function
• Previous (Step) Function
• Auto Function
• Fill
• Alignment
• Comparison with GROUP BY
• Join regularized series
• Interpolated Value Filter

# Partitioning

• Partitioning using Row Number Function
• Top-N Query using Row Number Function
• Row Number, Rank, and Dense Rank Functions
• Lag and Lead Functions
• Sliding and Unbound Windows
• Smoothing
• Last Time

# Subquery

• Inline Views

# Joins

• Join
• Join Using Entity
• Join: Derived Series
• Outer Join With Aggregation
• Outer Join

# Security

• Permissions

# Combined Examples

• PI Compatibility