sql查询员工入职多少天_sql 查询四舍五入_sql怎么四舍五入(16)

tb2.f5,tb3.f5,tb4.f5,tb5.f5

from t as tb1

left join t as tb2

on tb1.f0=tb2.f0 and tb2.f3=k4

left join t as tb3

on tb1.f0=tb3.f0 and tb3.f3=k3

left join t as tb4

on tb1.f0=tb4.f0 and tb4.f3=k2

left join t as tb5

on tb1.f0=tb5.f0 and tb5.f3=k1

grout by tb1.f2 order by tb1.scoresum desc

4.按各科不及格率的百分数从低到高和平均成绩从高到低顺序,统计并列印各科平均成绩和不及格率的百分数(用"N行"表示): (就是分析哪门课程难)

课程ID,课程名称,平均成绩,及格百分数

selectf3,f4, (select count(f1) from t where t.f4=tb.f4 and f5<60)/(select count(f1) from t where t.f4=tb.f4) as failper,((select sum(f5) from t where t.f4=tb.f4)/ (select count(f5) from t where t.f4=tb.f4)) as averagescore

from t tb order by failper asc, as averagescore desc

Top

/****** Object:Stored Procedure dbo.dt_checkoutobjectScript Date: 2003-3-12 9:25:26 ******/

create proc dbo.dt_checkoutobject

@chObjectTypechar(4),

@vchObjectName varchar(255),

@vchCommentvarchar(255),

@vchLoginNamevarchar(255),

@vchPassword varchar(255),

@iVCSFlags int = 0,

@iActionFlag int = 0/* 0 => Checkout, 1 => GetLatest, 2 => UndoCheckOut */

as

set nocount on

declare @iReturn int

declare @iObjectId int

select @iObjectId =0

declare @VSSGUID varchar(100)

select @VSSGUID = 'SQLVersionControl.VCS_SQL'

declare @iReturnValue int

select @iReturnValue = 0

declare @vchTempText varchar(255)

/* this is for our strings */

declare @iStreamObjectId int

select @iStreamObjectId = 0

declare @iPropertyObjectId int

select @iPropertyObjectId = (select objectid from dbo.dtproperties where property = 'VCSProjectID')

declare @vchProjectName varchar(255)

本文来自电脑杂谈，转载请注明本文网址：
https://www.pc-fly.com/a/ruanjian/article-30385-16.html