數(shù)據(jù)庫(kù)sql查詢例題及解答(編輯修改稿)
2025-04-21 02:56 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 where = and bid=63執(zhí)行結(jié)果，無(wú)問(wèn)題（4）查找租用過(guò)船只的船員編號(hào)：sid123456789101112131415161718：select distinct sidfrom Reserves3．執(zhí)行結(jié)果，無(wú)問(wèn)題（5）查找rating7且年齡25的水手編號(hào)：sid7：select sidfrom Sailorswhere rating7 and age253執(zhí)行結(jié)果:，無(wú)問(wèn)題（6）查找租用過(guò)紅船和白船的水手名字：sname張飛：select sidfrom Sailorswhere = and = and color=39。紅39。intersectselect sidfrom Sailorswhere = and = and color=39。白39。3執(zhí)行結(jié)果，改變實(shí)現(xiàn)語(yǔ)句 【2．實(shí)現(xiàn)語(yǔ)句：select snamefrom Sailors,Reserves,Boatswhere = and = and color=39。紅39。 And sname in(select snamefrom Sailors,Reserves,Boatswhere = and = and color=39。白39。) ： ?！浚?）查找租用過(guò)紅船或綠船的水手編號(hào)：si
黨政相關(guān)相關(guān)推薦
鄂ICP備17016276號(hào)-1