1樓：阿肆肆肆
純手打，望採納！
（1）select * from department
(2) select * from employee where ezipcode = '210010' order by eno desc,dno
(3) select ename,etel,email from employee where dno = (select dno from department where dname = '經理辦公室' )
(4)select * from employee
(5) select * from employee where ebirth between '1985-06-02' and getdate()
(6) select ename,etel,email from employee where eno in
(select eno from salary where salary > 3000 )
2樓：alex老夏
1.select * from department;
2.select * from employee where ezipcode='210010' order by eno desc,dno asc;
3.select ename,etel,email from department a join employeeb on a.dno=b.
dno where a.dname='經理辦公室';
4.select * from employee;
5.select * from employee where ebirth<'1985-06-01' order by eno asc,dno desc;
sql不會寫了
3樓：匿名使用者
方法太多了，效能需要去測。
第一個可以，
1.選擇查詢最大和最小的日期
2.直接top1升序降序 union
會編寫sql語句的幫忙寫下
4樓：
update card set password = replace(replace(password, 'o','0' ), 'i','1')
5樓：匿名使用者
update card
set password=replace(replace(password,'o','0'),'i','1')
如何使用sql編寫查詢語句用於查詢學生的各科成績
declare sql varchar 8000 select sql select a.mname as 學生姓名 select sql sql sum case c.fname when fname then b.score else null end as fname from f selec...
寫出對應的SQL語句，寫出SQL語句
1select from 雇員 where 尊稱 女士 2select count 0 as 銷售代表人數 from 雇員 where 職務 銷售代表 3select 雇員id,姓名，職務 from 雇員 4update 雇員 set 尊稱 mr where 尊稱 先生 5delete 雇員 whe...
簡單的sql語句
如果是 access 資料庫的話,不支援 要分開寫 conn.execute delete from gongqiu where id 62 conn.execute insert into admin admin,password values asdasd asdasd 如果是sql serve...