currently look same sex some question!!!
来源:互联网 发布:linux的sed命令 编辑:程序博客网 时间:2024/05/22 16:36
create table wage(wage money,name1 char(4),sex char(2))
insert wage values(100.1,'zxy1','男')
select *
from wage
insert wage values(100.2,'zxz','男')
go
insert wage values(100.2,'zxl','女')
go
insert wage values(100.2,'zxw','女')
go
insert wage values(100.2,'zxx','男')
go
select count(name1)as samesexcount ---统计出同性之人数
from wage
group by sex
go
select sum(wage)as samesexcount ----统计出同性工资之和
from wage
group by sex
create procedure proc_print
@wage money out,
@count int out,@num int out,@money money out
as
set @wage=(select aw.avg_wage
from (select avg(wage) as avg_wage,sex from wage,Employees
where wage.EmployeeID=Employees.EmployeeID and sex='男'
group by sex) as aw)
set @count=(select an.sex_wage
from (select count(sex) as sex_wage,sex from wage,Employees
where wage.EmployeeID=Employees.EmployeeID and sex='男'
group by sex) as an)
select * from Employees
declare @wage money
declare @money money
declare @count int
declare @num int
execute proc_print @wage out,count out,@num out,@money out
print(convert(nvarchar(40),@wage))
print(convert(nvarchar(40),@num))
alter procedure proc_print
@wage money out,
@count int out
as
set @wage=(select aw.avg_wage
from (select avg(wage) as avg_wage,sex from wage,Employees
where wage.EmployeeID=Employees.EmployeeID and sex='男'
group by sex) as aw)
set @count=(select an.sex_wage
from (select count(sex) as sex_wage,sex from wage,Employees
where wage.EmployeeID=Employees.EmployeeID and sex='男'
group by sex) as an)
select * from Employees
go
declare @wage money
declare @count int
execute proc_print @wage out,@count out
print(convert(nvarchar(40),@wage))
print(convert(nvarchar(40),@count))
- currently look same sex some question!!!
- some question
- some Form question & answer
- Some good question.
- some question of Gradle
- some basic interview question
- Some Question About ASP.NET
- some non-tech related question
- sex
- 【leetcode】100. Same Tree My Submissions Question
- Sql Server Some Question --Case...Whne...(1)
- Sql Server Some Question --Case...Whne...(2)
- Look at all the people out watching some sun
- Some links haven't take a look(C++, JS, IE9)
- Some issues encountered in Node.js First Look
- Sql Server Some Question --Select Interzone(区间的) Data
- look
- look
- 转贴一个SQLSERVER圈子的作品!!!
- ASP.NET 2.0中合并 GridView 的表头单元格
- 模拟Windows选项卡
- 常用的Javascript
- 简单测试动态游标(REF CURSOR)的使用
- currently look same sex some question!!!
- Huffman编码的8种实现方式
- 浅谈 接口(Interface)的作用
- cf卡读写总是要出点问题,总也找不到确切的原因
- 内部类学习(五)--静态内部类(Static Inner Class)
- 玩弄互联网的寒潮,有必要吗?
- Web服务器和应用程序服务器有什么区别?(zz)
- Symbian OS 精要
- 拒绝Cookie信息的四种方法