website logo
⌘K
🏠Homepage
👋Introduction
Key Concepts & Architecture
🚀Run Oxla in 2 minutes
🏃‍♂️Run Oxla on S3
🛫Multi-node Deployment
👨‍💻SQL Reference
SQL Queries
SQL Clauses
SQL Data Types
SQL Functions
Schema
Comment Support
🚨Error Handling
🆚Differences Between Oxla vs. PostgreSQL
📈Public Metrics
Docs powered by
Archbee
SQL Reference
SQL Queries

SQL TABLE

6min

What is a TABLE?

A table is a collection of data organized in rows and columns.

💡 A table has a specified number of columns but can have any number of rows.

How does a TABLE work?

You may easily create data for real-time analysis and reporting by using the query TABLE. It can connect datasets, filter datasets, apply SQL query functions, batch together datasets (union), and more.

In tables, data is systematically arranged in a row-and-column structure like a spreadsheet. Each column represents a record field, and each row represents a detailed record.

Let's see an example of a library table:

book_ID

book_Name

book_Author

00001

The Catcher in the Rye

J. D. Salinger

00002

Anna Karenina

Leo Tolstoy

In the above table:

  • "library" is the table's name.
  • "book_ID", "book_Name" and "book_Author" are the names of columns.
  • The combination of data from multiple columns creates a row, e.g. (00002, "Anna Karenina,” and “Leo Tolstoy").

What can we do with the TABLE?

You can perform various operations using a table. We do support some of the table operations, such as:

  1. Create a new table.
  2. Delete an existing table.
  3. Display a list of data from an existing table.
  4. Display a list of data from tables using 'join'. And many more…💨

By default, the table will be created in the public schema. Furthermore, you can also create and specify tables to other specific schemas. Click here for more info.



Updated 31 Aug 2023
Did this page help you?
PREVIOUS
SQL Queries
NEXT
CREATE TABLE statement
Docs powered by
Archbee
TABLE OF CONTENTS
What is a TABLE?
How does a TABLE work?
What can we do with the TABLE?
Docs powered by
Archbee

Dedicated to data analytics that provides 10x faster execution of analytical queries than current state of the art solutions. We are launching SOON! Join the waiting list for more info.




©2023 Oxla