Skip to main content

SQL QUERY

MySQL is a popular relational database management system used to store and manage data. Here are some common SQL queries with examples and explanations:


1. SELECT Query:

   - Example: `SELECT * FROM employees;`

   - Explanation: This query retrieves all columns (`*`) from the "employees" table, returning all rows.


2. WHERE Clause:

   - Example: `SELECT * FROM employees WHERE department = 'HR';`

   - Explanation: This query retrieves all columns from the "employees" table where the "department" column has the value 'HR'.


3. ORDER BY Clause:

   - Example: `SELECT * FROM employees ORDER BY salary DESC;`

   - Explanation: This query retrieves all columns from the "employees" table and sorts the result in descending order based on the "salary" column.


4. INSERT INTO Query:

   - Example: `INSERT INTO employees (name, age, department) VALUES ('John Doe', 30, 'IT');`

   - Explanation: This query inserts a new record into the "employees" table with specified values for the "name", "age", and "department" columns.


5. UPDATE Query:

   - Example: `UPDATE employees SET salary = 50000 WHERE department = 'Finance';`

   - Explanation: This query updates the "salary" column to 50000 for all rows in the "employees" table where the "department" column has the value 'Finance'.


6. DELETE Query:

   - Example: `DELETE FROM employees WHERE age > 60;`

   - Explanation: This query deletes all rows from the "employees" table where the "age" column is greater than 60.


7. JOIN Clause:

   - Example: `SELECT employees.name, departments.department_name FROM employees JOIN departments ON employees.department_id = departments.id;`

   - Explanation: This query retrieves the "name" column from the "employees" table and the "department_name" column from the "departments" table, joining them based on the "department_id" and "id" columns, respectively.


These are just a few examples of MySQL queries. Remember that SQL syntax may vary slightly depending on the specific database system you are using, but the principles remain consistent.

Comments