CenZn的博客

1分组查询员工表中的最大入职时间和最小入职时间的相差天数(DIFFRENCE）SELECT DATEDIFF(MAX(hiredate) , MIN(hiredate)) diffrence FROM employees;查询部门编号为90的员工个数SELECT COUNT(*) FROM employees WHERE `department_id`= 90;查询每个工种的最高工资SELECT MAX(salary),job_id FROM employees GROUP BY jo

目录结果导入maven坐标<?xml version="1.0" encoding="UTF-8"?><project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLoc...

创建数据库create database ‘数据库名称’; (注意末尾有英文分号)create database one;判读数据库不存在再创建数据库create database if not exists ‘数据库名称’;create database if not exists one;删除数据库drop database ‘数据库名称’;drop database o...