上海大學(xué)數(shù)據(jù)庫上機(jī)作業(yè)上機(jī)練習(xí)(編輯修改稿)
2024-08-20 14:41 本頁面
【文章內(nèi)容簡介】 RT INTO worker VALUES(20,39。陳立39。,39。女39。,39。55/03/0839。,1,39。75/10/1039。,4)GO INSERT INTO depart VALUES(5,39。設(shè)備處39。)GOSELECT ,FROM worker FULL JOIN depart ON(=)ORDER BY GODELETE FROM worker WHERE 職工號=39。2039。GODELETE FROM depart WHERE 部門號=39。539。GO factorySELECT ,FROM worker,salary,depart WHERE = AND =AND =(SELECT MAX(工資) FROM salary) factorySELECT 部門名FROM depart WHERE 部門號=(SELECT 部門號 FROM worker WHERE 職工號=(SELECT 職工號 FROM salary WHERE 工資=(SELECT MAX(工資) FROM salary ))) factorySELECT 職工號,姓名FROM worker WHERE 職工號 IN(SELECT 職工號 FROM salary GROUP BY 職工號 HAVING AVG(工資)(SELECT AVG(工資) FROM salary )) factoryGO SET NOCOUNT ON 聲明變量DECLARE @dname char(10) 聲明游標(biāo)DECLARE d_cursor CURSO
研究報(bào)告相關(guān)推薦
鄂ICP備17016276號-1