热门标签
更多>
搜索结果
查询Tags标签: minsal,共有 2条记录-
sql和数据库
```sqlselect deptno,min(sal) from emp group by deptno ;select d.dname,a.minsal,e.ename from dept d left join (select deptno,min(sal) minsal from emp group by deptno)a on d.deptno=a.deptnoleft join emp eon e.sal=a.minsal;```事务commit\rollbackexecute i…
2021/7/10 2:05:40 人评论 次浏览 -
sql和数据库
```sqlselect deptno,min(sal) from emp group by deptno ;select d.dname,a.minsal,e.ename from dept d left join (select deptno,min(sal) minsal from emp group by deptno)a on d.deptno=a.deptnoleft join emp eon e.sal=a.minsal;```事务commit\rollbackexecute i…
2021/7/10 2:05:40 人评论 次浏览