How can SQL be used to retrieve data?

SQL is a language used to manage relational database systems, enabling data retrieval through query statements.

Below are some common examples of SQL query statements:

1. SELECT statement: Used to retrieve data from a database.
   Example: SELECT * FROM table_name;
2. WHERE clause: Used to filter data and retrieve records based on specified conditions.
   Example: SELECT * FROM table_name WHERE column_name = value;
3. ORDER BY statement: used to sort the results.
   Example: SELECT * FROM table_name ORDER BY column_name ASC|DESC;
4. LIMIT statement: used to restrict the number of results returned.
   Example: SELECT * FROM table_name LIMIT quantity;
5. GROUP BY statement: used to group the results by a specified column.
   Example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name;
6. JOIN statement: Used to retrieve correlated data from multiple tables.
   Example: SELECT * FROM table1 JOIN table2 ON table1.column_name = table2.column_name;
7. DISTINCT statement: used to retrieve unique values.
   Example: SELECT DISTINCT column_name FROM table_name;
8. IN statement: Used to specify a range of conditions, similar to multiple OR conditions.
   Example: SELECT * FROM table_name WHERE column_name IN (value1, value2, value3);

These are just a portion of SQL query statements. SQL also has many other features and syntax that can enable complex data retrieval operations. Please use appropriate SQL statements for data retrieval based on specific requirements and database system criteria.