请用sql语句写出下面的需求谢谢

求大神们指点下写出sql语句谢谢

举报该文章

第1个回答 2014-09-24

--SQL2008
--1
SELECT A.*,(SELECT SUM(Cash_In-Cash_Out)
FROM (SELECT 1 AS ID, 1000 as Cash_In, 0 AS Cash_Out
UNION SELECT 2 AS ID,0 AS Case_IN, 200 AS Cash_Out
UNION SELECT 3 AS ID,1500 AS Case_IN, 0 AS Cash_Out
UNION SELECT 4 AS ID,0 AS Case_IN, 200 AS Cash_Out
UNION SELECT 5 AS ID,0 AS Case_IN, 200 AS Cash_Out
)B
WHERE B.ID <= A.ID) AS CashNow
FROM
(SELECT 1 AS ID, 1000 as Cash_In, 0 AS Cash_Out
UNION SELECT 2 AS ID,0 AS Case_IN, 200 AS Cash_Out
UNION SELECT 3 AS ID,1500 AS Case_IN, 0 AS Cash_Out
UNION SELECT 4 AS ID,0 AS Case_IN, 200 AS Cash_Out
UNION SELECT 5 AS ID,0 AS Case_IN, 200 AS Cash_Out
)A
ORDER BY ID
--2
CREATE TABLE #A ( ID int,C1 varchar(10))
INSERT INTO #A
--SELECT 1 ,'AB'
--SELECT 2 ,'AC'
--SELECT 0 ,'bc'
--SELECT 0 ,'cc'
--SELECT 0 ,'bc'
SELECT CASE ID WHEN 0 THEN (ROW_NUMBER()OVER (partition by id ORDER BY id )
+(SELECT MAX(ID) FROM #A) )
ELSE ID END AS ID_New
, C1
FROM #A
ORDER BY ID_New

第2个回答 2014-09-24

select id,收入,支出,sum(decode(收入,null,0,收入)-decode(支出,null,0，支出)) over(order by id) 余额 from tt;

create sequence s_test start with 3 increment by 1;
update test set 序号=s_test.nextval where 序号=0;

写出以下的SQL语句,谢谢啦。【access数据库的应用】
1.select 姓名,性别,职称,基础工资+岗位工资+绩效工资 AS 工资总额 from 教师2.select 姓名,性别,部门名称,担任职务,职称 from 教师 inner join 部门 on 教师.部门编号=部门.部门编号3.select * from 教师 order by 基础工资4.select * from 教师 inner join 部门 on 教师.部门编号=部门.部门...

用SQL语句完成以下操作
from 学生表 a,成绩表 b where a.学号=b.学号希望你能通过以上的答案，自己弄懂都是什么意思，over

写出实现下列操作的SQL语句。
select a.学号,a.成绩 from 选修 a,课程 b where a.课程号=b.课程号 and b.课程名='3号'order by a.成绩 desc -- 如果不是按课程名查，可以不用连接"课程"表 2)select a.课程号,b.课程名,count(a.学好)from 选修 a,课程 b where a.课程号=b.课程号 group by a.课程号,b.课程...

...如下表所示,要求分别用一条SQL语句写出所问的问题。
select * from s where 学号 in (select 学号 from sc,t where sc.成绩=t.成绩 group by 学号 having sum(t.奖学金)>0) and 性别='女'

写SQL语句来帮忙
1)select A.姓名 from (select * from S) A inner jion (select * from SC) B on A.学号=B.学号 inner join (select * from C) D on B.课程号=D.课程号 where D.选修课程='1' and D.选修课程='2'2)select A.姓名,D.课程名 from (select * from S) A inner jion (select ...

关于SQL语句,谢谢!
as 总空程 ,sum(QJZ)as 总桥架子 ,sum(XSH) as 总小时,sum(YJ) as 总运距 from t_glgz group by SJ where ND="'+nd+'" and YD="'+yd+'" and LB="'+lb+'"'上面的Having换成Where，Having只限于包含聚合函数的条件如：having sum(tsh) > 200 而不是这样的情况应该用where ...

按要求写出如下T-SQL语句
1、insert into 产品表 values(0001 空调 3000 200),(0002,'冰箱', 2500 ,100),(0003,'彩电', 2800, 50),(0004, '电脑', 3200, 100)2、update 产品表 set 价格=价格*0.83、delete from 产品表 where 价格<504、select 产品名称 from 产品表 where 价格 between 2000 and 29005、select ...

SQL语句求助谢谢大家
select t1.* from 表名 t1,(select a,max(b) b from 表名 where c like '%123%' group by a) t2 where t1.a=t2.a and t1.b=t2.b and t1.c like '%123%'晕啊，我也发现了

求高手帮助我写个SQL语句!万分感谢!
sum(case when 仓库=A then 库存 else 0 end) AS A库存,sum(case when 仓库=B then 销售 else 0 end) AS B销售,sum(case when 仓库=B then 库存 else 0 end) AS B库存,sum(case when 仓库=C then 销售 else 0 end) AS C销售,sum(case when 仓库=C then 库存 else 0 end) AS ...

请帮忙写个sql语句
select d.id as 人员编号,sum(a.price)as 累计消费金额1,sum(b.price)as 累计消费金额2，sum(c.price)as 累计消费金额3 from 人员表 d left outer join 消费表1 a on a.id=d.id left outer join 消费表2 b on a.id=d.id left outer join 消费表3 c on a.id=d.id where (a....

相似回答

大家正在搜

请用sql语句写出下面的需求 谢谢

请用sql语句写出下面的需求谢谢