- 博客(2)
- 资源 (1)
- 收藏
- 关注
RSS订阅原创 pychram运行出错
C:\Program Files (x86)\JetBrains\PyCharm 5.0.3\helpers\pydev\_pydev_imps\_pydev_execfile.py___jb_bak___ (拒绝访问。)因为是python2的工程，在pytho3的pychram中运行，不兼容导致unable to display frame variables预发错误，缺少‘（）
2016-06-23 10:53:59
825
原创 安装python
第一步1、https://www.python.org/downloads/下载最新版2、如果是64位，必须用X68 -64标示的第二步1、正常安装。最好安装安装在C盘2、path中添加：C:\Python35\Scripts\;C:\Python35\;3、运行的窗口中，输入python，和pip。结果正常即可第三步：1、运行的窗口中，pip install se
2016-06-18 22:46:55
309
SQLQuery5.sql
/**----
select * from KuChun
select * from Sell
select sum(SellNum)as Sumd,SellID,ProductType from Sell group by SellID,ProductType
select *
from KuChun t1 left join (select SellID, sum(sellnum)as snum,ProductType from Sell group by SellID,ProductType)t2
on t1.ShopID=t2.SellID and t1.ProductType=t2.ProductType
order by t1.ShopID
SELECT T1.SHOPID, T1.PRODUCTTYPE, T1.KNUM, (select ISNULL(sum(t2.sellnum),0) from Sell t2 where t2.sellid = t1.shopid and t2.producttype= t1.productType) sumsell
FROM KuChun T1
order by t1.shopid;
select T1.SHOPID, T1.PRODUCTTYPE, T1.KNUM, ISNULL(sum(t2.sellnum),0) sellnum
from KuChun t1
left join Sell t2
on t2.sellid = t1.shopid and t2.producttype= t1.productType
group by T1.SHOPID, T1.PRODUCTTYPE, T1.KNUM
order by t1.shopid;
select T1.SHOPID, T1.PRODUCTTYPE, sum(T1.KNUM) knum, ISNULL(sum(t2.sellnum),0) sellnum
from KuChun t1
left join Sell t2
on t2.sellid = t1.shopid and t2.producttype= t1.productType
group by T1.SHOPID, T1.PRODUCTTYPE
order by t1.shopid;
select c.*,a.s_score as '01课程 score',b.s_score as '02课程 score' from score a,score b
left join student c on b.s_id = c.s_id
where a.s_id = b.s_id and a.c_id = '01' and b.c_id = '02' and a.s_score > b.s_score;
**/
---ALTER TABLE KuChun ALTER COLUMN Knum int;
select * from student t2
select * from Course t3
select * from Teacher t4
select * from Score t1
-- 50、查询下月过生日的学生
select * from(
select ss.* ,datename(mm,ss.s_birth) as wk,datename(mm,getdate()) as wk1 from Student ss )tt
where tt.wk=tt.wk1+1
-- 49、查询本月过生日的学生
select ss.*,datename(mm,ss.s_birth) from Student ss where datename(mm,getdate())=datename(mm,ss.s_birth)
-- 48、查询下周过生日的学生
select * from(
select ss.*,datename(wk,ss.s_birth)as'周数', cast( datename(wk,ss.s_birth) as decimal)- datename(wk,getdate()) as wk from Student ss
)tt
where tt.wk=1
-- 47、查询本周过生日的学生
select ss.* from Student ss where datename(wk,ss.s_birth)=datename(wk,get
2020-02-09
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人