ai写sql,

🗣 SL提问: ai写sql

✍️ Ai批改: 当然！以下是一个简单的SQL查询示例，假设你有一个名为 `employees` 的表，表中包含以下列：

`id` (员工ID)
`name` (员工姓名)
`department` (部门)
`salary` (薪水)

示例1：查询所有员工的信息
sql
SELECT * FROM employees;

示例2：查询特定部门的员工
sql
SELECT name, salary
FROM employees
WHERE department = 'Sales';

示例3：查询薪水高于某个值的员工
sql
SELECT name, department, salary
FROM employees
WHERE salary 50000;

示例4：按部门分组并计算每个部门的平均薪水
sql
SELECT department, AVG(salary) AS avg_salary
FROM employees
GROUP BY department;

示例5：插入新员工记录
sql
INSERT INTO employees (id, name, department, salary)
VALUES (101, 'John Doe', 'Engineering', 75000);

示例6：更新员工的薪水
sql
UPDATE employees
SET salary = 80000
WHERE id = 101;

示例7：删除特定员工记录
sql
DELETE FROM employees
WHERE id = 101;

示例8：查询薪水最高的员工
sql
SELECT name, salary
FROM employees
ORDER BY salary DESC
LIMIT 1;

示例9：查询每个部门薪水最高的员工
sql
SELECT department, name, MAX(salary) AS max_salary
FROM employees
GROUP BY department;

示例10：查询员工总数
sql
SELECT COUNT(*) AS total_employees
FROM employees;

这些示例涵盖了SQL中的基本操作，包括查询、插入、更新、删除和聚合函数。你可以根据实际需求调整这些查询。如果你有更具体的需求或问题，请告诉我！