第4章數(shù)據(jù)庫(kù)及應(yīng)用程序開(kāi)發(fā)——關(guān)系數(shù)據(jù)庫(kù)標(biāo)準(zhǔn)語(yǔ)言sql(編輯修改稿)
2024-11-03 16:05 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 e price* FROM titles WHERE price price*18 ? SELECT pub_id, pub_name FROM publishers WHERE country=’USA’ AND state=’CA’ 21 (c) LIKE ? 列名 [NOT] LIKE 模式 ? %: 任意字符串 , _:任意一個(gè)字符 ? ? SELECT au_lname+’.’+au_fname, city+’.’+state FROM authors WHERE au_fname LIKE ‘D%’ 22 ? SELECT au_lname+’.’+au_fname, city+’.’+state FROM authors WHERE au_id LIKE ‘72_%’ 23 24 25 其他的條件查詢(xún) 26 (5) 結(jié)果排序 ? ORDER BY 字段表 ? 通常返回的結(jié)果是隨機(jī)排列的 。 ? SELECT stor_name, city FROM stores ORDER BY store_name 27 ? SELECT stor_name, city FROM stores ORDER BY store_name DESC ? ? SELECT stor_name, city FROM stores ORDER BY store_name ASC ? SELECT stor_name, city FROM stores ORDER BY stor_name， city ? 用多個(gè)列排列 。 ? ? SELECT stor_name, city FROM stores ORDER BY state ? 用不出現(xiàn)的列 。 29 (6) 統(tǒng)計(jì)函數(shù) 30 ? SELECT AVG(price) FROM titles ? ? SELECT MAX(price) FROM titles WHERE type=’business’ 31 ? SELECT AVG(qty), SUM(qty), COUNT(DISTICT stor_id) FROM sales ? ? SELECT COUNT（ *） FROM publishers WHERE state=’CA’ 32 (7) 結(jié)果分組 ? GROUP BY 分組列名表 ? SELECT type, AVG(price), SUM(price), COUNT(*) FROM titles WHERE type in (39。business39。, 39。mod_c
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號(hào)-1