SQL Query Interview Questions and Answers
Ques 1. What is SQL?
SQL (Structured Query Language) is a domain-specific language used for managing and manipulating relational databases.
Is it helpful?
Add Comment
View Comments
Ques 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.
Is it helpful?
Add Comment
View Comments
Ques 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;
Is it helpful?
Add Comment
View Comments
Ques 4. What is normalization?
Normalization is the process of organizing data in a database to reduce redundancy and dependency.
Is it helpful?
Add Comment
View Comments
Ques 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);
Is it helpful?
Add Comment
View Comments
Most helpful rated by users: