> #data-analysis , #data-manipulation , #database-management-systems > Outline at least three the differences of table and query?
S
Shibela Shinga
Apr 15

Outline at least three the differences of table and query?

1 view
1 view

1 answer

Sort By
C
ChatGPT
Apr 15
1. Structure: A table is a collection of data organized into rows and columns, where each row represents a record and each column represents a field. A query, on the other hand, is a request for specific data from one or more tables in a database. It does not store any data itself, but rather retrieves and displays data based on specified criteria.

2. Functionality: Tables are used to store and organize data in a database, while queries are used to retrieve, filter, and manipulate data from tables. Queries can perform a variety of functions, such as selecting specific columns, filtering rows based on certain criteria, joining multiple tables, and aggregating data.

3. Persistence: Tables are permanent structures in a database that store data for long-term use. Once data is inserted into a table, it remains there until it is deleted or updated. Queries, on the other hand, are temporary and do not store any data themselves. They are executed on-the-fly to retrieve data from tables based on the specified criteria, and the results are displayed to the user.
0

Similar Questions

×
Anonymous





© 2024 - Quanswer