SQL Query 面试题与答案

问题 16. Explain the GROUP BY clause.

The GROUP BY clause is used in a SELECT statement to arrange identical data into groups, typically used with aggregate functions.

Example:

SELECT column, COUNT(*) FROM table GROUP BY column;

问题 17. What is a stored procedure?

A stored procedure is a set of SQL statements that can be stored in the database and executed by calling the procedure.

问题 18. Write a SQL query to find duplicate records in a table.

SELECT column, COUNT(*) FROM table GROUP BY column HAVING COUNT(*) > 1;

问题 19. Explain the purpose of the HAVING clause.

The HAVING clause is used in combination with the GROUP BY clause to filter the results of aggregate functions based on specified conditions.

Example:

SELECT column, COUNT(*) FROM table GROUP BY column HAVING COUNT(*) > 1;

问题 20. What is a view in a database?

A view is a virtual table based on the result of a SELECT query, and it does not store the data itself.

Example:

CREATE VIEW view_name AS SELECT column1, column2 FROM table WHERE condition;