Mysql查询详解(条件查询、子查询、模糊查询、连接查询。。。)
Mysql练习题,可对本章学习的内容进行巩固
dept.sql
emp.sql
salgrade.sql
查询每个员工的工资
给查询列起别名
条件查询需要用到where语句,where语句必须放到from语句后面。
==语法格式如下==
==条件查询支持以下运算符==
==查询工资为5000的员工姓名==
==搭配%使用==
(1)
(2)
(3)
==搭配_使用==
==注意事项==
==连接查询分类==
查询每个员工的部门名称,要求显示员工名和部门名
找出每个员工的工资等级,要求显示员工名、工资、工资等级
找出每个员工的上级领导,要求显示员工名和对应的领导名称
外连接分类
==1、where后面嵌套子查询==
==2、from后面嵌套子查询==
列出各种工作的最低工资及从事此工作的雇员姓名
3、select后面嵌套子查询
查询每个员工所在部门名称
觉得不错的小伙伴可以点赞关注和收藏哦!如有错误可以指出来。
<font size="4">Java学习路线目录索引</font>
绛旓細鍓嶈█ 鎴戜滑鍦ㄤ互鍓,澶ф瀛︿簡涓涓嬪浣曢氳繃鍛戒护 鍒涘缓鏁版嵁搴 ,鍒涘缓琛 绛夊熀鏈搷浣溿備絾鏄疄闄呬笂鍟,鑷冲皯鍦ㄦ垜鐨勫疄闄呭伐浣滀腑,鐢ㄥ埌鐨勪笉鏄お澶,浜嗚В灏卞彲浠ャ傚洜涓烘垜浠彲浠ラ氳繃涓浜 鍙鍖栬蒋浠 ,鍍廚avicat for MySQL绛夈傚彲浠ュ緢鏂逛究鐨勫府鍔╂垜浠 鍒涘缓鏁版嵁搴 ,鍒涘缓琛 ,淇敼琛 绛夋搷浣溿侼avicat for MySQL绠鍗曠ず渚嬪垱寤烘暟鎹簱...
绛旓細mysql鍙敤涓鏉ql璇彞鏌ュ嚭涓涓〃閲屼笉鍚鏉′欢瀵瑰簲鐨勬暟鎹潯鏁扮殑姝ラ濡備笅锛氭垜浠渶瑕佸噯澶囩殑鏉愭枡鍒嗗埆鏄細鐢佃剳銆sql鏌ヨ鍣ㄣ1銆侀鍏堬紝鎵撳紑sql鏌ヨ鍣紝杩炴帴涓婄浉搴旂殑鏁版嵁搴撹〃锛屼緥濡俿tu2琛ㄣ2銆佺偣鍑烩滄煡璇⑩濇寜閽紝杈撳叆锛歴elect count(*) from stu2 where sex=1 and age=2 union all select count(*) from ...
绛旓細璇彞椤哄簭 select 閫夋嫨鐨勫垪 from 琛 where 鏌ヨ鐨鏉′欢 group by 鍒嗙粍灞炴 having 鍒嗙粍杩囨护鐨勬潯浠 order by 鎺掑簭灞炴 limit 璧峰璁板綍浣嶇疆锛屽彇璁板綍鐨勬潯鏁 鍏朵腑 select 閫夋嫨鐨勫垪 from 琛 where 鏌ヨ鐨勬潯浠 浠ヤ笂鏄熀鏈殑缁撴瀯 group by 鍒嗙粍灞炴 having 鍒嗙粍杩囨护鐨勬潯浠 杩欎釜鏄寜鐓у垎缁勫睘鎬ц繘琛屽垎缁...
绛旓細SELECT CASE WHEN (age >=20 and age <25) THEN 0 CASE WHEN (age >=25 and age <=30) THEN 1 ELSE -1 END FROM student鐢╟ase when case when 鏉′欢1 then 鍊1 when 鏉′欢2 then 鍊2 else 鍊3 end
绛旓細MySQL鏌ヨ骞撮緞锛屾湁浠ヤ笅鍑犵鏂瑰紡锛鏉′欢锛氳〃涓拡瀵瑰勾榫勭殑瀛楁鍚嶅亣濡備负age瀛楁锛堝叾浠栧悕瀛椾篃鍙互锛夋煡璇㈠崟鏉¤褰曪紝閫氳繃宸叉湁瀛楁淇℃伅鍖归厤鏌ヨ锛濡傚鍚峮ame涓衡滃紶涓夆濇垨鑰卛d涓1 SELECT age FROM 琛ㄥ悕 where name="寮犱笁";SELECT age FROM 琛ㄥ悕 where id = 1;鏌ヨ鎵鏈夎褰曪紝鐩存帴鑾峰彇鎵鏈塧ge瀛楁鏁版嵁 SELECT age ...
绛旓細缁欎綘鎬濊矾锛屽叿浣撲綘鑷繁鍘诲啓锛1.浣犺繖涓槸鏈変簩绫绘潯浠讹細蹇呴夌殑锛氬墠浜屼釜2閫1锛涘悗闈笁涓潯浠舵槸鍙夌殑锛岄夊叏閮ㄧ瓑浜庢病閫夊氨娌″繀瑕佸姞杩欎釜鏉′欢锛鍏抽敭瀛楁病濉殑璇濈瓑鍚岋紱鎵浠ヤ綘鍏跺疄灏辨槸1锛4涓潯浠躲2.瀹炵幇寤鸿鐢ㄥ瓨鍌ㄨ繃绋嬶紝鍙傛暟鏍规嵁瀹為檯鎯呭喌浼犻锛屾潯浠瓒婂鏌ヨ瓒婃參锛岃秺鎱(鑰梒pu鍜宨o)鐨勬潯浠惰鏀惧湪璇彞鐨勬渶鍚庛
绛旓細C#杩炴帴mysql鏁版嵁搴撳浣曞疄鐜板鏉′欢鏌ヨ 100 濡傞,鍦ㄤ竴涓枃鏈閲岃緭鍏ユ瘮濡傚鍚嶆垨鑰呭鍙风殑鏌ヨ鏉′欢,閫氳繃涓涓寜閽潵杩涜鏌ヨ,浠g爜濡備綍瀹炵幇... 濡傞,鍦ㄤ竴涓枃鏈閲岃緭鍏ユ瘮濡傚鍚嶆垨鑰呭鍙风殑鏌ヨ鏉′欢,閫氳繃涓涓寜閽潵杩涜鏌ヨ,浠g爜濡備綍瀹炵幇 灞曞紑 鎴戞潵绛
绛旓細绗竴绉 exists涓巒ot exists select * from table1 t1 where exists(select columnName from table2 t2 where t1.columnName2 = t2.columnName2)绗簩绉嶏紝in锛宯ot in鐨勭敤娉 select * from table1 where columnName in(select columnName from table2 where columnNane = 'condition')绗笁绉,any...
绛旓細select t1.id as id,t1.lang as clang,t1.name as cname,t2.lang as elang,t2.name as ename,t3.lang as rlang,t3.name as rname from ((select * from translate where lang=1) as t1 LEFT JOIN (select * from translate where lang=2) as t2 on t1.id=t2.id)LEFT JOIN (...
绛旓細mysql鍒ゆ柇绗﹀悎鏌ヨ鏉′欢鐨勬暟鎹湁涓ゆ潯鏍规嵁鏌ヨ鐩稿叧璧勬枡锛1銆佹煡璇㈡暟鎹簱琛ㄦ暟鎹紝鏍规嵁鎸囧畾鏉′欢绛涢夊嚭婊¤冻鏉′欢鐨勬暟鎹紝姝や緥杩斿洖婊¤冻鏉′欢鐨勪袱鏉℃暟鎹2銆佸叧閿瓧鏌ヨ锛浣跨敤AND鎼滅储鏍忚緭鍏ョ鍚堟潯浠剁殑鏁版嵁銆