中國石油大學(xué)華東數(shù)據(jù)庫實(shí)驗(yàn)四龔安共五篇-wenkub
2024-11-16 03 本頁面
【正文】 ect zuoyexiangmuhao,shigongdanwei from xiangmubiao where shigongdanwei=39。⒁ 作業(yè)公司二隊(duì)參與了哪些項(xiàng)目。⒀ 找出消耗了材料三且消耗超過了2000元的項(xiàng)目，列出相應(yīng)消耗明細(xì)(利用子查詢)。采油一礦二隊(duì)39。⑼ 有哪些人員參與了入賬操作。 and ruzhangriqi between 39。201152839。采油一礦二隊(duì)39。 and 39。select jiesuanzonge=sum(jiesuanjine)from danweidaimabiao, xiangmubiao where yusuandanwei=danweidaima and danweimingcheng=39。20115139。⑸ 列出采油一礦二隊(duì)201151到2011528總的預(yù)算金額。 and ruzhangriqi between 39。 and =。 and jiesuanriqi between 39。201152839。采油一礦二隊(duì)39。 and yusuanriqi=39。drop index ruzhangriqisuoyin on xiangmubiao。create index jiesuanriqisuoyin on xiangmubiao(jiesuanriqi)。create index ruzhangriqisuoyin on xiangmubiao(ruzhangriqi)。2.⑴ 采油一礦二隊(duì)201151到2011528有哪些項(xiàng)目完成了預(yù)算，列出相應(yīng)明細(xì)。20115139。 and jiesuanriqi between 39。⑶ 采油一礦二隊(duì)201151到2011528有哪些項(xiàng)目完成了結(jié)算，列出相應(yīng)的材料費(fèi)消耗明細(xì)。20115139。⑷ 采油一礦二隊(duì)201151到2011528有哪些項(xiàng)目完成了入賬，列出相應(yīng)明細(xì)。20115139。select yusuanzonge=sum(yusuanjine)from danweidaimabiao, xiangmubiao where yusuandanwei=danweidaima and danweimingcheng=39。 and 39。采油一礦二隊(duì)39。201152839。 and ruzhangriqi between 39。⑻ 列出采油一礦201151到2011528總的入賬金額。20115139。select distinct ruzhangren from xiangmubiao where ruzhangren is not null⑽ 列出201151到2011528進(jìn)行了結(jié)算但未入帳的項(xiàng)目。 and yusuandanwei=danweidaima order by ruzhangjine desc。Selectzuoyexiangmuhao,wuma,xiaohaoshuliang,danjia from cailiaofeibiao where wuma in(select wuma from wumabiao where mingchengguige=39。select zuoyexiangmuhao from xiangmubiao where shigongdanwei=39。作業(yè)公司作業(yè)二隊(duì)39。select shigongdanwei from xiangmubiao,youshuijingbiao,danweidaimabiao where yusuandanwei= and = and danweimingcheng like 39。⑶ 用帶子查詢的修改語句將采油一礦油井作業(yè)項(xiàng)目的結(jié)算人改為“李兵”。采油一礦%39。采油一礦%39。 where yusuandanwei in(select danweidaima fromdanweidaimabiao where danweidaima=yusuandanwei and danweimingcheng like 39。deletefrom xiangmubiao where yusuandanwei in(select danweidaima from danweidaimabiao where danweidaima=yusuandanwei and danweimingcheng like 39。select zuoyexiangmuhao,yusuandanwei from xiangmubiao。如何避免這種現(xiàn)象的發(fā)生，曾經(jīng)設(shè)想了好久，能不能給煙灰缸增加一個(gè)活動(dòng)的蓋子，以防止煙灰的隨風(fēng)散落呢？經(jīng)過多次的設(shè)計(jì)、試驗(yàn)、失敗、改進(jìn)，一次次的重復(fù)實(shí)驗(yàn)，最終成型，設(shè)計(jì)成功了一種環(huán)保煙灰缸，并獲得了中華人民共和國實(shí)用新型專利,取得了國家知識(shí)產(chǎn)權(quán)局頒發(fā)的實(shí)用新型專利證書。我有時(shí)候會(huì)因?yàn)榇中模敢恍┎辉摮霈F(xiàn)的錯(cuò)誤。憑借著高中三年如一日的努力，我的成績一直名列年級(jí)前茅，考試成績只能證明過去，我必須堅(jiān)持努力，勤奮鉆研，我相信，中國石油大學(xué)（華東）的大門將為我敞開著。int WINAPI WinMain(HINSTANCE hThisInst, HINSTANCE hPrevInst, LPSTR lpszCmdLine, int nCmdShow){WNDCLASS ws。 = WndProc。 = LoadIcon(NULL, IDI_HAND)。 = “DemoClass”。ShowWindow(hWnd,nCmdShow)。msg)。}LRESULT CALLBACK WndProc(HWND hwnd,UINT messgae, WPARAM wParam,LPARAM lParam){switch(messgae){case WM_DESTROY: PostQuitMessage(0)。}三、實(shí)驗(yàn)報(bào)告(1)列出源程序清單，以及程序的運(yùn)行結(jié)果；include “” LRESULT CALLBACK WndProc(HWND hwnd,UINT messgae,WPARAM wParam,LPARAM lParam)。 = 0。//cbClsExtra Specifies the amount of extra memory, in bytes, that Windows should reserve for the = 0。//hCursor光標(biāo)句柄//LoadCursor該函數(shù)從一個(gè)與應(yīng)用事例相關(guān)的可執(zhí)行文件(EXE文件)中載入指定的光標(biāo)資源 //IDC_CROSS 十字光標(biāo) =(HBRUSH)GetStockObject(WHITE_BRUSH)。ws))//RegisterClass注冊(cè)窗口類{ return1。//參數(shù)
教學(xué)教案相關(guān)推薦
鄂ICP備17016276號(hào)-1