<a class="btn btn-secondary" id="bookmark"><i class="fa fa-bookmark-o fa-md" aria-hidden="true"></i> 收藏 </a><a class="btn btn-secondary" href="https://sqltutorial.cn/seeit/"><i class="fa fa-home fa-md" aria-hidden="true"></i> 主页</a><a class="btn btn-secondary" href="https://sqltutorial.cn/contact-us/"><i class="fa fa-envelope-o fa-md" aria-hidden="true"></i> 联系 </a>
<h6 class="list-group-item-heading">#1 </h6> <pre class="list-group-item-text" id="1">SELECT SUM(salary) FROM employees;</pre> </a> <a href="#2" class="list-group-item sql"> <h6 class="list-group-item-heading">#2 </h6> <pre class="list-group-item-text" id="2">SELECT SUM(salary) FROM employees WHERE department_id = 5;</pre> </a> <a href="#3" class="list-group-item sql"> <h6 class="list-group-item-heading">#3 </h6> <pre class="list-group-item-text" id="3">SELECT department_id, SUM(salary) FROM employees GROUP BY department_id;</pre> </a> <a href="#4" class="list-group-item sql"> <h6 class="list-group-item-heading">#4 </h6> <pre class="list-group-item-text" id="4">SELECT e.department_id, department_name, SUM(salary) FROM employees e INNER JOIN departments d ON d.department_id = e.department_id GROUP BY e.department_id;</pre> </a> <a href="#5" class="list-group-item sql"> <h6 class="list-group-item-heading">#5 </h6> <pre class="list-group-item-text" id="5">SELECT e.department_id, department_name, SUM(salary) FROM employees e INNER JOIN departments d ON d.department_id = e.department_id GROUP BY e.department_id ORDER BY SUM(salary) DESC;</pre> </a> <a href="#6" class="list-group-item sql"> <h6 class="list-group-item-heading">#6 </h6> <pre class="list-group-item-text" id="6">SELECT e.department_id, department_name, SUM(salary) FROM employees e INNER JOIN departments d ON d.department_id = e.department_id GROUP BY e.department_id HAVING SUM(salary) > 30000 ORDER BY SUM(salary) DESC;</pre> </a>
表格列表 </a> <a href="#countries" class="list-group-item sql"> <h6 class="list-group-item-heading">countries</h6> <pre class="list-group-item-text" id="countries" style="display:none">SELECT * FROM countries;</pre> </a> <a href="#departments" class="list-group-item sql"> <h6 class="list-group-item-heading">departments</h6> <pre class="list-group-item-text" id="departments" style="display:none">SELECT * FROM departments;</pre> </a> <a href="#dependents" class="list-group-item sql"> <h6 class="list-group-item-heading">dependents</h6> <pre class="list-group-item-text" id="dependents" style="display:none">SELECT * FROM dependents;</pre> </a> <a href="#employees" class="list-group-item sql"> <h6 class="list-group-item-heading">employees</h6> <pre class="list-group-item-text" id="employees" style="display:none">SELECT * FROM employees;</pre> </a> <a href="#jobs" class="list-group-item sql"> <h6 class="list-group-item-heading">jobs</h6> <pre class="list-group-item-text" id="jobs" style="display:none">SELECT * FROM jobs;</pre> </a> <a href="#locations" class="list-group-item sql"> <h6 class="list-group-item-heading">locations</h6> <pre class="list-group-item-text" id="locations" style="display:none">SELECT * FROM locations;</pre> </a> <a href="#regions" class="list-group-item sql"> <h6 class="list-group-item-heading">regions</h6> <pre class="list-group-item-text" id="regions" style="display:none">SELECT * FROM regions;</pre> </a>
<i class="fa fa-play fa-md" aria-hidden="true"></i>执行
<a id="clear" class="btn btn-secondary"> <i class="fa fa-eraser fa-md" aria-hidden="true"></i> 清除</a><a id="beautify" class="btn btn-secondary"><i class="fa fa-magic fa-md" aria-hidden="true"></i> 美化</a><a id="minify" class="btn btn-secondary"><i class="fa fa-compress fa-md" aria-hidden="true"></i> 压缩</a>
<i class="fa fa-history fa-md" aria-hidden="true"></i> 重新加载