使用mysql完成题目二1 CREATE TABLE emp2 empno INT3 ename VARCHAR504 job VARCHAR505 mgr INT6 hiredate DATE7 sal DECIMAL728 comm decimal729 deptno INT10 ;111213 INSERT INTO emp values7369SMITHCLERK79021980‐12‐

日期: 2026-05-26 23:28:37
标签: 社会

SELECT COUNT(*) FROM emp;
SELECT COUNT(*) FROM emp WHERE sal > 2500;
SELECT COUNT() FROM emp WHERE comm IS NOT NULL; SELECT COUNT() FROM emp WHERE mgr IS NOT NULL;

使用mysql完成题目二1 CREATE TABLE emp2 empno INT3 ename VARCHAR504 job VARCHAR505 mgr INT6 hiredate DATE7 sal DECIMAL728 comm decimal729 deptno INT10 ;111213 INSERT INTO emp values7369SMITHCLERK79021980‐12‐

原文地址: http://www.cveoy.top/t/topic/fPhs 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录