nba球員球隊(duì)信息管理系統(tǒng)項(xiàng)目設(shè)計(jì)方案(劉嘯塵-魏春月)(參考版)
2025-05-06 01:54本頁(yè)面
【正文】 總而言之，通過(guò)這次的學(xué)習(xí)，我們受益匪淺。from pc截圖結(jié)果查詢場(chǎng)均得分最高的前%的球員信息select top 10 percent * from pcorder by 場(chǎng)均得分desc截圖結(jié)果排序增加刪除數(shù)據(jù)按名次從大到小，勝率從小到大排序select * from QCorder by 名次Desc,勝率asc截圖結(jié)果需要向表中增加數(shù)據(jù)的代碼為表球員參賽表（pc）增加列Comments，可以為空NullAlter Table PCAdd Comments varchar(20)select * from pc截圖結(jié)果需要向表中刪除數(shù)據(jù)的代碼刪除一列Alter Table pc DROP COLUMN mentsSELECT * FROM pc截圖結(jié)果第四章 總結(jié)系統(tǒng)大概的功能比如：球員信息的查詢，修改，刪除等均可實(shí)現(xiàn)。截圖結(jié)果未知值（null）查詢查詢?cè)诟黜?xiàng)比賽中沒(méi)有獲得任何個(gè)人獎(jiǎng)項(xiàng)的球員信息select * from PC where 個(gè)人獎(jiǎng)項(xiàng)IS NULL截圖結(jié)果查詢場(chǎng)均得分超過(guò)分的人數(shù)select Count (*) AS 39。截圖結(jié)果查詢常規(guī)賽mvp的詳細(xì)信息select * from pC where 個(gè)人獎(jiǎng)項(xiàng)=39。from player截圖結(jié)果統(tǒng)計(jì)球員表中球員的年齡總和select Sum(年齡)From player截圖結(jié)果查詢各隊(duì)季前賽的名次和勝率select * from QC where 比賽類(lèi)型=39。from player截圖結(jié)果查詢球員表中球員的平均年齡select Sum(年齡)/12 AS 39。截圖結(jié)果查詢球員表中球員年齡不超過(guò)的人數(shù)select Count (*) AS 39。and39。截圖結(jié)果查詢球員表中加盟時(shí)間在0801到0801的球員select * from player where 加盟時(shí)間between 39。,null)創(chuàng)建索引球隊(duì)名create unique index IX_球隊(duì)名on team(球隊(duì)名)創(chuàng)建索引身高create index IX_身高on player(身高)創(chuàng)建索引球員姓名create index IX_球員姓名on player(球員姓名)該數(shù)據(jù)的查詢功能—查詢語(yǔ)句多條件組合查詢查詢球員表中國(guó)籍是美國(guó)的所有球員select * from player where 國(guó)籍=39。,39。,39。)insert into PC values (39。,39。,39。,39。)insert into PC values (39。,39。,39。,39。)insert into PC values (39。,39。,39。, 39。,null)insert into PC values (39。,39。, 39。,null)insert into PC values (39。,39。, 39。)insert into PC values (39。,39。,39。, 39。,null)insert into PC values (39。,39。, 39。,null)insert into PC values (39。,39。, 39。)insert into PC values (39。,39。,39。, 39。)insert into PC values (39。,39。,39。, 39。)insert into PC values (39。,39。,39。, 39。)向球員參賽表加入數(shù)據(jù)insert into PC values(39。,39。,39。,39。)insert into QC values(39。,39。,39。,39。)insert into QC values(39。,39。,39。,39。)insert into QC values(39。,39。,39。,39。)insert into QC values(39。,39。,39。,39。)insert into QC values(39。,39。,39。,39。)insert into QC values(39。,39。,39。,39。)insert into QC values(39。,39。,39。,39。)insert into QC values (39。,39。,3
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1