@import url("https://fonts.googleapis.com/css2?family=Space+Grotesk:wght@300..700&display=swap");body {
  font-family: "Space Grotesk", sans-serif;
}

.dark p {
  color: white;
}

.ring-transparent {
  transition: 0.5s ease-in-out;
}

.ring-transparent:hover {
  box-shadow: 1px 1px 21px -1px rgba(49, 57, 219, 0.64);
  -webkit-box-shadow: 1px 1px 21px -1px rgba(49, 57, 219, 0.64);
  -moz-box-shadow: 1px 1px 21px -1px rgba(49, 57, 219, 0.64);
}

:is(.dark .dark\:bg-codeblock\/50) {
  filter: brightness();
}

:is(.dark .dark\:bg-codeblock\/50) svg {
  filter: brightness(10);
}

:is(.dark .dark\:bg-codeblock\/50):hover {
  filter: brightness(10);
}

:is(.dark .dark\:text-primary-light) {
  color: rgb(152 157 255);
}

/* for white color in dark mode */
.prose:is(.dark *) {
  color: white;
}

/* for black color in light mode */
.prose {
  color: black;
}

/* for a clearer code format in dark mode */
:not(pre) > code:is(.dark *) {
  background: transparent;
  border-width: 0;
}

/* for a clearer code format in light mode */
:not(pre) > code {
  background: transparent;
  border-width: 0;
}


What are Clauses? 🤔

Overview

Oxla Developer Hub

Discover everything you need to know about Oxla right here, right now!

Welcome

Key Concepts & Architecture

OLTP vs OLAP

Oxla vs. Other OLAP Solutions

Run Oxla in 2 minutes

Run Oxla on S3

Multi-Node Deployment

Run Multi-node oxla cluster with host mounted network storage

Run Oxla via AWS

Run Oxla on Google Cloud Storage

Run Oxla on Azure Blob Storage

SQL TABLE

CREATE INDEX

SELECT

INSERT INTO

DROP

SHOW TABLES

DESCRIBE

SHOW NODES

SET/SHOW

WHERE

GROUP BY

HAVING

ORDER BY

LIMIT

OFFSET

WITH

OVER / WINDOW

Data Type Operators

Bool

Date

Timestamp Without Time Zone

Timestamp with Time Zone

Interval

Text

JSON

Array

Trigonometric Functions

Schema

Comment Support

UPDATE

DELETE

pg_description

pg_settings

pg_index

pg_namespace

pg_attrdef

pg_depend

pg_constraint

pg_statio_user_tables

pg_type

pg_attribute

pg_class

Oxla Home Files

Data Task Stability

C# Dapper - Npgsql

Java JDBC

PHP PDO

Roles

Privileges

Ownership

Error Handling

Differences Between Oxla vs. PostgreSQL

Understanding Transactions

Handling Oxla Degraded State

Public Metrics

Oxla Configuration File

SSL Configuration

Product Roadmap

Blog

Changelog

Introduction

Getting Started

SQL Reference

SQL Mutations

System Catalogs

Language Clients

Access Control

Resources

Overview

What are Clauses? 🤔

FROM

WHERE

GROUP BY

HAVING

ORDER BY

LIMIT

OFFSET

Set Operations

WITH

OVER / WINDOW

Introduction

Getting Started

SQL Reference

SQL Mutations

System Catalogs

Language Clients

Access Control

Resources

​What are Clauses? 🤔

FROM

WHERE

GROUP BY

HAVING

ORDER BY

LIMIT

OFFSET

Set Operations

WITH

OVER / WINDOW

What are Clauses? 🤔