數(shù)據(jù)庫(kù)技術(shù)及應(yīng)用(第2版)課后習(xí)題答案-在線(xiàn)瀏覽
2024-08-06 06:05本頁(yè)面
【正文】 t emp_id,fname+39。+lname as 39。,Year(getdate())Year(hire_date) as 39。 from employee order by 39。、 select * from employee where fname like 39。、 select * from employee where job_id=39。、 select emp_id,fname+39。+lname as 39。, Year(getdate())Year(hire_date) as worketimefrom employee where (Year(getdate())Year(hire_date)) 5 order by worketime、 select * from employee where cast(job_id as integer)=5 and cast(job_id as integer)= select * from employee where fname=39。、 select * from employee where fname like 39。 or lname like 39。、 select * from sales where ord_date 39。、 select distinct bh, zyh from stu_info where bh in (select bh from stu_infogroup by (bh) having count(*)30 and count(*)40 ) order by bh或者是select bh,zyh from stu_infogroup by zyh,bhhaving count(bh)30 and count(bh)40order by bh、 select * from gban where bh like 39。、 select * from gfied where zym like 39。、select xh,xm,zym,rxsj from stu_info,gfied,gban where nl23 and = and =、 select zyh,count(*) from gban where xsh=39。 group by zyh實(shí)驗(yàn)4Select xh,xm,xbm from stu_info,gdept where = and =’信息科學(xué)與工程’或 Select xh,xm,xbm from stu_info where xsh=(select xsh from gdept where xsm=’信息科學(xué)與工程’)Select ,xm,km from stu_info,xk,gcourse where = and = and kscj85 Select xh,xm,xsm from stu_info,gdept where = and xh like ‘2000%’Select xh, xm from stu_info where xh in (select xh from xk where kch=’090101’ and kscj60)或 select ,xm from stu_info,xk where = and kch=’090101’ and kscj60 select ,xm,km
數(shù)學(xué)相關(guān)推薦
鄂ICP備17016276號(hào)-1