SQL Query вопросы и ответы для интервью

Вопрос 1. What is SQL?

SQL (Structured Query Language) is a domain-specific language used for managing and manipulating relational databases.

Вопрос 2. What is the difference between SQL and MySQL?

SQL is a language, whereas MySQL is a relational database management system that uses SQL as its query language.

Вопрос 3. Explain the SELECT statement.

The SELECT statement is used to query the database and retrieve data from one or more tables.

Example:

SELECT column1, column2 FROM table WHERE condition;

Вопрос 4. What is normalization?

Normalization is the process of organizing data in a database to reduce redundancy and dependency.

Вопрос 5. Write a SQL query to find the second highest salary from an Employee table.

SELECT MAX(salary) FROM Employee WHERE salary < (SELECT MAX(salary) FROM Employee);