Shibela Shinga
Apr 15
Outline at least three the differences of table and query?
1 view
1 view
1 answer
Sort By
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.
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
