SQL TABLE

​

What is a TABLE?

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

​

How does a TABLE work?

You may easily create data for real-time analysis and reporting by using the statement TABLE. It can connect datasets, filter datasets, apply SQL 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:

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…💨