SQL语句查询以下问题 用SQL语句如何对以下几个问题进行查询？
oracle \u91cc\u7684\u67e5\u8be2\u65f6\u95f4\u95ee\u9898 sql\u8bed\u53e5\u7ed9\u4f60\u4e00\u4e2a\u53c2\u8003\u7684\u5199\u6cd5\uff1a
select *
from \u75c5\u4eba\u4fe1\u606f
where \u767b\u8bb0\u65f6\u95f4 between
to_date('2005-05-08 00:00:00', 'yyyy-mm-dd hh24:mi:ss') and
to_date('2005-08-08 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
and to_char(\u767b\u8bb0\u65f6\u95f4,'hh24:mi:ss') = '07:39:29'
1\u3001select employee_name from works where salary>(select max(salary)
from works where company_name='Small Bank Corporation');
2\u3001select company_name,num from
(select company_name,count(*) num from works group by company_name order by num desc)
where rownum=1;
3\u3001select company_name from tab
where sal>(select sal from tab where company_name='First Bank Corporation');
\u5176\u4e2d\uff1atab=>(select company_name,avg(salary) sal from works group by company_name)
1. select avg(图书定价的平均值) from table <> where 图书名 = <>
2. select min(图书定价），图书名，定价 from table <>
3. 假设publish 表示出版社的名称，改语句表示：
列出哪个出版社（无重复的列示）的图书定价的平均值大于机械工业出版社的图书定价的平均值
4. select 借书的人的姓名 from table <> where datetime = '2005-2-3'
注意这个时间格式要符合数据库的要求，一般会用 datetime = todate('2005-2-3， 'yyyy-mm-dd')
5. select 借书的人的姓名，图书名 from table <> where datetime = '2005-2-3'
11题：
假设 只有一个表a
字段如下 pcid出版社ID price图书定价 bid书ID
select avg(price),pcid from a
where pcid in (select pcid from (select count(bid)as num,pcid from a
group by pcid ) tmp
where num>=2)
group by pcid
数据：
pcid bid price
1 1 10
1 2 10
2 3 20
2 4 20
1 5 10
3 6 30
结果:
avg(price) pcid
10 1
20 2
你的表和字段都没给出来，叫别人怎么给你写SQL语句。还好从13题从 看出了book表的一些字段信息。
13题的语句是 查出 图书平均价格大于机械工业出版社图书平均价格的 出版社
15 sele 人,书 from 借书表 wher date=05/02/03
14 sele dist name frmo 借书表 wher date=05/02/03
13查找平均图书定价高于机械工业出版社平均定价的出版社
12 sele book,price from 表 wher price=min(price)
楼主是来求作业答案吗？
绛旓細--闂1(鎴戞湁涓涓枒闂綘杩欎釜闇姹備細鍑虹幇缂栧彿閲嶅鎶)INSERT INTO books(book_id,book_name,au_id,type,price,qty)SELECT book_id+1000,book_name,au_id,type,price,0 FROM books WHERE book_id=N --闂2 SELECT A.au_id,A.au_name,SUM(ISNULL(B.qty,0)) AS SUM_qty FROM authors A...
绛旓細1銆佺涓棰橈紝鏄煡璇㈡诲拰锛屾诲拰鍦⊿QL涓娇鐢╯um锛屽锛歴elect sum(鎴愮哗) from 琛ㄥ悕 2銆佺浜岄锛屾煡璇㈠钩鍧囧硷紝SQl锛歴elect 瀛﹀彿锛孉vg(sum(鎴愮哗)) from 琛ㄥ悕 group by 瀛﹀彿 3銆佺涓夐锛屾煡璇㈡瘡璇剧▼瀛︾敓浜烘暟锛孲QL : select 璇剧▼鍚嶇О,count(瀛﹀彿) from 琛ㄥ悕 group by 璇剧▼鍚嶇О 4銆佺鍥涢锛屾煡璇㈡渶楂...
绛旓細棣栧厛鎴戜滑闇瑕鏌ョ湅user1鐢ㄦ埛鐨刪ost锛岃繖閲岀殑host瀛楁锛屽彲浠ラ檺鍒剁敤鎴疯闂暟鎹簱鐨刬p鍦板潃锛岃缁嗚嚜琛屾煡闃呰祫鏂欍傚彲浠ヤ娇鐢ㄥ涓璇彞 mysql 鐢ㄦ埛host鏌ヨ 鍋囪user1 鐨 host 鏄 %锛屼慨鏀规巿鏉冧竴鑸负澧炲垹鏀规煡锛屽洜姝よ鍙ュ涓 mysql 鍗曡〃鏉冮檺 绗叚棰橈細 绱㈠紩娑夊強琛ㄧ粨鏋勪慨鏀癸紝浣跨敤 ALTER 璇彞 mysql 娣诲姞绱㈠紩 绗竷棰橈細鍏宠仈...
绛旓細锛2锛変竴涓梾鍘嗗彿鍙兘浼氬彂鐢熷绗旇垂鐢紝璇鏌ヨ姣忎釜鐥呬汉鐨勬昏垂鐢紝骞舵寜鐓涓嬪垪鏂瑰紡琛ㄧ幇 鐥呭巻鍙 鐥呬汉濮撳悕 鎬昏垂鐢 鎸傚彿鏃堕棿 SELECT B.CCASENO AS '鐥呭巻鍙',A.SICKNAME AS '鐥呬汉濮撳悕',SUM(B.DEBITSUM) AS '鎬昏垂鐢',A.REGTM AS '鎸傚彿鏃堕棿'FROM A ,B WHERE B.CCASENO=A.CCASENO GROUP BY ...
绛旓細濡傛灉鍙槸涓や釜琛紝鍙互鐢╱nion 鎶婅繖浜涙暟鎹兘鏌ュ嚭鏉ャ俿elect 鍒0,鍒1 from dbo.1-5 where 鍒1 = '10327177'union select 鍒0,鍒1 from dbo.35w where 鍒1 = '10327177'濡傛灉鏈夋洿鏂板叾浠栬〃锛岃岃繖浜涜〃鏈変竴瀹氱殑瑙勫緥鎬э紝灏辨槸鍙互鐢ㄥ惊鐜+鍔ㄦSQL瀹炵幇 declare @sql varchar(max)set @sql = 'select ...
绛旓細鐢⊿ql璇彞鏌ヨ鎸囧畾琛ㄦ牸涓寚瀹氬瓧娈电殑鏁版嵁绫诲瀷 涓銆佽鍙ラ氳繃systypes锛宻yscolumns锛宻ysobjects锛屼笁涓郴缁熻〃鏍艰仈鍚堟绱㈣幏鍙栫粨鏋溿俿ystypes锛氭暟鎹簱鏀寔鐨勬暟鎹被鍨嬪睘鎬с俿yscolumns锛氭暟鎹簱涓悇琛ㄦ牸缁撴瀯灞炴с俿ysobjects锛氭暟鎹簱涓墍鏈夊璞＄殑灞炴с備簩銆佹绱㈣鍙ユ紨绀 1銆佺ず渚嬭〃鏍硷細base_zwb 2銆佽鍙ュ涓嬶細select name from...
绛旓細select sc.sno from sc , student where student.sno = sc.sno and student.sdept = 'CS'鍥犳锛宻dept鏄潵鑷猻tudent琛ㄧ殑 杩欐牱鐨鏌ヨ鍙浉鍏冲瓙鏌ヨ锛屼篃灏辨槸璇翠粠sc琛ㄦ煡鍑虹殑姣忎竴琛屽潎闇鍐嶆閫氳繃鍐呭眰鐨勫瓙鏌ヨ鍐嶆鍦⊿tudent琛ㄤ腑鏌ヨ涓娆dept鍊硷紝鐪嬪叾鏄惁绛変簬鈥楥S鈥欍傝繖鏍风殑鏌ヨ鏁堢巼鍗佸垎浣庝笅锛屼竴鑸笉鎺ㄨ崘浣跨敤...
绛旓細鍦鏌ヨ鐨勫悕绉板瓧娈甸噷闈㈠啀娣诲姞涓涓瓙鏌ヨ锛屾埅鍙栫紪鍙风殑鍓嶅叚浣嶄綔涓烘潯浠讹紝鐢╨eft鍑芥暟鎴彇锛屽皢缁撴灉鐢╟oncat鍑芥暟涓庤嚜韬殑鍚嶇О鎷兼帴鍗冲彲
绛旓細浣跨敤濡備笅SQL璇彞鏌ヨ鍑鸿〃涓閿害鏉熷悕绉帮細select name from sys.foreign_key_columns f join sys.objects o on f.constraint_object_id=o.object_id where f.parent_object_id=object_id('琛ㄥ悕')alter table 琛ㄥ悕 drop constraint 澶栭敭绾︽潫鍚 ...
绛旓細and not exists(select 1 from table where name=a.name and type<>1 and creat<a.creat )棰樼洰涓嶉毦锛岃В娉曟湁寰堝锛屾ゼ涓荤殑璇彞缁撴灉鏄鐨勶紝浣嗙畻娉曟晥鐜囦笉濂斤紝灏变綘鏈韩鐨勭畻娉曞氨鏈夊緢澶氬彲浼樺寲鐨勫湴鏂癸紝瀛鏌ヨ鍙互灏戝祵濂椾竴灞傦紝<=灏忎簬鍙峰彲浠ュ幓鎺夛紝asc榛樿鎺掑簭鍙互鐪佺暐 select name,type from (select name...
