SQL Query perguntas e respostas de entrevista

Pergunta 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;

Pergunta 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.

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

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

Pergunta 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;

Pergunta 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;