Question

Types of query's in database

Answer 1

[AI-generated answer — Bot GPT 3.5]

1. Select query: Retrieves data from one or more tables based on specific criteria.

2. Update query: Modifies existing data in a table.

3. Insert query: Adds new data into a table.

4. Delete query: Removes data from a table.

5. Join query: Combines data from multiple tables based on a common column.

6. Aggregate query: Performs calculations across multiple rows, such as finding the sum, average, or count of a set of values.

7. Subquery: A query nested within another query to further refine the results.

8. Union query: Combines the results of two or more queries into a single result set.

9. Create query: Creates a new table, index, or view in the database.

10. Alter query: Modifies the structure of an existing table, such as adding or removing columns.