摘要：
http://www.webkaka.com/blog/archives/how-to-modify-a-web-page-to-be-responsive.html 一天完成把PC网站改为自适应！原来这么简单！ 作者:Kaka 时间:2015-8-27 11:26:9 浏览:5279 评论:8 网 阅读全文
posted @ 2016-07-28 14:13
从未被超越
阅读(7173)
评论(1)
推荐(0)
摘要：
--投资情况统计详情sqlselect BidRecord.*, RegInfo.UserName,UserInfo.phone,BorrowInfo.Title,BorrowInfo.BorrowCode from--(select * from [YYD_Account_MoneyRecord] 阅读全文
posted @ 2016-07-25 15:39
从未被超越
阅读(267)
评论(0)
推荐(0)
摘要：
select COUNT(*) from YYD_Users_RegInfo where regTime between '2016-07-11 00:00:00' and '2016-07-11 23:59:59' union all select COUNT(*) from YYD_Users_ 阅读全文
posted @ 2016-07-25 15:38
从未被超越
阅读(281)
评论(0)
推荐(0)
摘要：
select dtime1,SUM(fkje) as fkje,(select sum(borrow_amount) from yyd_borrow_borrowinfo where (status=10 or status=20) and loandate<=tongjitb.dtime1 --张 阅读全文
posted @ 2016-07-25 15:38
从未被超越
阅读(883)
评论(0)
推荐(0)
摘要：
select --总注册人数(select COUNT(*) from [YYD_Users_RegInfo]) as TotalCount,--pc端注册人数(select COUNT(*) from [YYD_Users_RegInfo] where regPlatform ='pc') as 阅读全文
posted @ 2016-07-25 15:37
从未被超越
阅读(359)
评论(0)
推荐(0)
摘要：
随心买统计查询 --随心买新增-当日人次select COUNT(*) from(select distinct userID from HUR_Product_Buy where createDate between '2016-07-12 00:00:00' and '2016-07-12 23 阅读全文
posted @ 2016-07-25 15:36
从未被超越
阅读(216)
评论(0)
推荐(0)
摘要：
declare @time datetime set @time='2016-07-01' --最新的电Call记录统计查询--SELECT t.zuoxi1,t.PhoneCount,t.PhoneCountSC,t.zuoxi2,t.RegUserCount,t.zuoxi3,t.Recharg 阅读全文
posted @ 2016-07-25 15:35
从未被超越
阅读(337)
评论(0)
推荐(0)
摘要：
--普通标、定向标、新手标、老互融计划-投资记录表select bid.borrow_id, (select yyb.borrow_valid_time from YYD_Borrow_BorrowInfo as yyb where yyb.ID=bid.borrow_id ) as borrow_ 阅读全文
posted @ 2016-07-25 15:34
从未被超越
阅读(235)
评论(0)
推荐(0)
摘要：
DECLARE @startTime datetimeset @startTime='2016-07-12' SELECT * FROM (--坐席号/电话个数/通话总时长select zuoxi as zuoxi1,COUNT(1) as PhoneCount,SUM(DATEDIFF(ss,jt 阅读全文
posted @ 2016-07-25 15:33
从未被超越
阅读(464)
评论(0)
推荐(0)
摘要：
Union all的用法实例sqlSELECT TOP (100) PERCENT ID, bid_user_id, UserName, amount, createtime, borrowTypeFROM (SELECT bid.ID, bid.bid_user_id, reg.UserName, 阅读全文
posted @ 2016-07-25 15:32
从未被超越
阅读(1129)
评论(0)
推荐(0)
浙公网安备 33010602011771号