简单查询
cyx_chen
迎难而上
展开
-
基于银行数据库查找练习
--3.8 a 找出银行中所有有账户但无贷款的客户select distinct customer_name from depositor where customer_name not in( select customer_name from borrower)--下面这个自动去掉了重复值的情况 不需要加distinctselect customer_name from de...原创 2019-01-13 10:10:16 · 2433 阅读 · 3 评论 -
雇员数据库查询
--3.9--a.找出所有为'small Bank Corporation'工作的雇员的名字及其居住的城市select employee.employee_name,cityfrom employee join works on(employee.employee_name=works.employee_name)where company_name='small Bank Corpor...原创 2019-01-13 10:10:53 · 2989 阅读 · 0 评论