What is the purpose of the SELECT statement in SQL?
- Define the structure of a database table
- Delete records from a table
- Modify existing records in a table
- Retrieve data from a database
The SELECT statement in SQL is used to retrieve data from one or more tables in a database. It allows users to specify the columns they want to retrieve and apply filters to narrow down the results. This statement is fundamental for querying databases and fetching information based on specific criteria.
Loading...
Related Quiz
- In DB2, user-defined functions are typically stored in ________.
- User-defined functions can return ________ values in DB2.
- Scenario: A DBA needs to find the average salary of all employees in a department. Which aggregation function should they use in DB2, and why?
- How does DB2 integrate with other technologies?
- User-defined functions in DB2 can be implemented using ________ language.