c***t
发帖数: 383 | 1 【 以下文字转载自 Notice 讨论区 】
发信人: deliver (自动发信系统), 信区:
标 题: count 封 deadman451 在 WaterWorld 版
发信站: BBS 未名空间站自动发信系统 (Tue Aug 27 09:46:55 2013)
【此篇文章是由自动发信系统所张贴】
由于 deadman451 在 WaterWorld 版的 干扰版面讨论秩序 行为，
被暂时取消在本版的发文权力 14 天。
备注:3
版主:count
Tue Aug 27 09:46:43 2013 |
|
s***t
发帖数: 197 | 2 count on (inseparable): depend on; trust that something will happen or that
someone will do as expected.
"I'm counting on you to wake me up tomorrow. I know I won't hear the
alarm." |
|
n*****g
发帖数: 626 | 3 USTC Alumni Foundation Count Down to $1M
============================================
Total donation reached $949,131 on 4/15/2007
http://ustcaf.org
Dear Fellow USTCers,
As of April 15, 2007, the total donation received by USTC
Alumni Foundation has reached $949,131 -- counting
donations "in the mail", the total is practically above $950K
just $50K away from One Million US Dollars. History is in
the making. Recent surge in USTCAF donation benefited
from renewed support to U |
|
c******o
发帖数: 20 | 4 Anybody can give me some advice on what is a good way to count the lines of
code (LOC) in a C/C++ program? Is it good enough to count the number of
semicolons?
Thanks! |
|
f***e
发帖数: 17 | 5 我define 了table department,里面有nested table cars,现在怎么count 一共
有多少cars for all departments.
create or replace type CARTYPE as object
(
VIN NUMBER(17),
YEAR NUMBER(4),
MODEL VARCHAR2(60)
);
/
create or replace type CARTABLETYPE as table of CARTYPE;
/
create table Dept(
deptID integer constraint dept_pk primary key,
dname char(20) not null,
cars CartableType
)
nested table cars store as Cartable;
然后我用：
select sum(count(c.*)) from dept D,table(d.cars) c; |
|
g****s
发帖数: 1 | 6 我有一个temp table存着数十个table names
求教怎样只用SQL列出所有table的count(*)
具体就是如何把temp table得一个个表名转成变量被select count(*) from 认识
现在的做法是把table name list存入一个shell varible, 然后用shell的for loop一
个一个地死算，但是这样要进进出出dbaccess几十回，不好看，如果一次能在sql
level上搞定就好了。 |
|
m*t
发帖数: 7490 | 7 我有一个表，里面的一个field是1-1000里随即的一个数字
有什么最快的方法，能够把多个区间里的count一次显示出来
比如我想知道1-100，101-200，...901-1000的十个区间里的数字的个数
写语句一句一句的读不算，
例如 select count(*) from data where num>=1 and number<=100 的不行 |
|
b*****e
发帖数: 364 | 8 select Floor(Data/100) as RangeX, Count(*) as Counts
from data
Group by Floor(Data/100) |
|
n********6
发帖数: 1511 | 9 current output:
product, counter
apple 2
apple 3
orange x
Objective:
product, counter
apple 5
orange x
table1
transactionid, product
1, apple
2, orange
3, apple
...
m, banana
table2
transactionid, product
1, peach
2, apple
3, apple
...
n, apple
current code (to be modified)
select product, count(transactionid)
from table1
group by product
union
select product, count(transactionid)
from table2
group by product |
|
i****a
发帖数: 36252 | 10 select prodcut, sum(cnt)
(
select product, count(transactionid) as cnt
from table1
group by product
union ALL
select product, count(transactionid) as cnt
from table2
group by product
) x
group by x.product |
|
T****U
发帖数: 3344 | 11 恩，北京mm说得对
看看这个行不行？
select sku, received-sales Unitsleft, sales UnitsSold
from ((select count(*) sales, sku
from salesHistory group by sku) join
(select count(*) received, sku
from inventory group by sku)
Using (sku))
Where (received-sales)>10
order by sku |
|
r*********n
发帖数: 4553 | 12 S.M.A.R.T里面Reallocated Sector Count的数值已经有200多，超过treshold好多，在
hdtunepro里面这一项数值后面有个感叹号（但是还是没有坏道），但是在everest里面
却显示Value is normal，这是不是意味着硬盘就要挂了？
最近硬盘有时候会停止响应，导致系统死机，重启系统以后主板根本就识别不了硬盘，
就好像没有安装硬盘，直接跳过硬盘寻找其他驱动。但是非常诡异的是，过一段时间，
比如一天，然后硬盘又好了，又可以进系统了。是不是因为硬盘自动恢复了。
Google一下，貌似大多数人说已经无救了，但是有些人又说低级格式化有可以把
Reallocated Sector Count的数值重置为零。 |
|
|
F****3
发帖数: 1504 | 14 load cycle count上个星期到了600多次。然后用ultimate boot cd的wdidle3吧lcc改
成disable了。
改了以后也没注意，就拷贝了一些文件。发现好像压缩文件很慢。
今天在把1T文件夹拷到另外一个盘的时候，发现目前load cycle count显示是 93677.
是不是wdidle3把记录改了。请问有xdjm碰到类似情况吗？ |
|
a*****a
发帖数: 1429 | 15 你们不看vim的Tips?
十几年前vim出来的时候文挡里就有专门的tips，介绍如何Count words, lines, etc:
To count how often any pattern occurs in the current buffer use the
substitute command and add the 'n' flag to avoid the substitution. The
reported number of substitutions is the number of items. Examples:
> :%s/./&/gn characters
> :%s/\i\+/&/gn words
> :%s/^//n lines
> :%s/the/&/gn "the" anywhere
> :%s/\/&/gn "the" as a word |
|
t****t
发帖数: 6806 | 16 说的不错,补充一下
auto_ptr已经在standard里了.它不支持 reference counting,但是保证所指向的
object永远只有一个ownership.
shared_ptr是在tr1里,它是ref counting的.
另外有一个weak_ptr,和smart_ptr配合使用的,用来smart_ptr的循环链接造成的memory
leak(具体怎么弄其实我也搞不清).也在tr1里. |
|
e*******e
发帖数: 1837 | 17 最近开始学MySQL,发现包含COUNT()的query非常的慢.
我的query(两个table和要用到的column都已经index过了):
SELECT COUNT(*) FROM table_name AS t
INNER JOIN samples AS s ON t.ID = s.ID
GROUP BY s.group
在一个25,000 row 的表里运行这个query居然要20秒.大虾给看看有没有办法加快点?
多谢! |
|
d*********1
发帖数: 25 | 18 thanks for all the answers :) they are all right!
due to different parameters, varying classes yield. They are similar to:
class CountedClass : public Counted {};
class CountedClass2 : public Counted {};
as long as type1!=type2, eg int vs double etc. |
|
h**o
发帖数: 548 | 19 I have a files which records some activities of all functions.
I want to count how many times each of the function is called.
How to write a unix shell to count them?
or is there any other way?
Thanks |
|
i***h
发帖数: 12655 | 20 What function? You mean C/C++ function?
if in C,
void f() {
static int count = 0;
count++;
} |
|
h**o
发帖数: 548 | 21 forget about the function. Please think it as strings.
What I want is to count how many times each function name appear in this
file. While the size of the file is too large, I cannot count it with my
eyes and therefore want to write some shell. But I am a beginner of unix
shell. so I want to get some answers or hints here.
BTW, the format of the functions in this file is sth. like:
ADDR BUFADDR TIMESTAMP THREAD
CACHE LA |
|
c*****a
发帖数: 1638 | 22 没看懂你的问题。
count（distinct word）还是count（×）
不过答案是用counter，前者在reducr里面，后者在mapper里面 |
|
n****1
发帖数: 1136 | 23 还有就是如果出了cyclic reference, python里面是需要一个supplemental garbage
collection facility， 复杂度也接近gc了。这个机制可能触发得没有java频繁，所以
在python这种低速语言是可以接受，但swift越快这个负担就越重。
还有FP style code是会生成很多隐形的cyclic reference的，纯的ref counting根本
无解，这就是gc与lisp一同诞生的原由。Swift这种ref counting会导致FP style变成
鸡肋，那还不如去掉FP style呢
最后，如果swift需要手动保证acyclic的话，那debug就会比手动管理内存更加棘手。 |
|
h**o
发帖数: 548 | 24 I have a file which records the activities of all functions.
I want to count from this file how many times each of the function is called.
How to write a unix shell to count them?
or
is there any other way?
Thanks |
|
h**o
发帖数: 548 | 25 I have a file which records the activities of all functions.
I want to count from this file how many times each of the function is called.
How to write a unix shell to count them?
or
is there any other way?
Thanks |
|
k****n
发帖数: 3803 | 26 ☆─────────────────────────────────────☆
hehehehehe (hehehehe) 于 (Mon Apr 18 11:03:24 2011, 美东) 提到:
发信人: hehehehehe (hehehehe), 信区: Environmental
标 题: 请问local government的实习经验能用来count for PE的工作经验吗
发信站: BBS 未名空间站 (Mon Apr 18 11:02:58 2011, 美东)
谢谢
☆─────────────────────────────────────☆
sskyline (ss) 于 (Mon Apr 18 20:52:36 2011, 美东) 提到:
这个要看你实习的时候具体是做什么的，PE考试的报名条件里对工作经验的count写得
很清楚，自己上去对一下就行了。而且关键是这一段经历要有人给你做reference。 |
|
g*******y
发帖数: 380 | 27 Hi,all
I have a question as below:
I want count the total number of non-missing value for several variables by
year.
Suppose the dataset looks like this:
year varA varB varX varP....
I know I can do proc freq...; tables year*varA;
or proc sql;.. count(varA) as..;group by year;...
But how can I do it for several variables at once and get a single table?
Thank you in advance. |
|
j***3
发帖数: 142 | 28 I have a table like this:
color size fruit
red big apple
red small apple
green big apple
yellow small orange
red small orange
when I do:
select color, size, count(*) group by color, size;
I got:
red big 1
red small 2
green big 1
yellow small 1
but what I need is to also return the NULL group count such as:
red big 1
red small 2
green big 1
green small 0
yellow small 0
yellow small 1
how I can do the query in mysql?
thank you all. |
|
s*******y
发帖数: 2977 | 29 Can we test if a count data set follows negative-binomial distribution in
SAS? It seems we can check the over-dispersion of count data using deviance/
df, but this is for Poisson distribution only.
Any methods for negative-binomial distribution?
Thanks a lot in advance! |
|
y*****w
发帖数: 1350 | 30 If your count data does not include zero values, you can use PROC UNIVARIATE
with the HISTOGRAM statement to get goodness-of-fit test statistics for
several distributions, however those distributions do not include NB.
http://support.sas.com/documentation/cdl/en/procstat/63104/HTML
I have recently run a project in which I had to choose a best distribution
for my non-zero historical count data for the purpose of sample size
calculation. I applied the HISTOGRAM statement to compare GAMMA, LOGNORMA... 阅读全帖 |
|
J********J
发帖数: 571 | 31 spec上写的: unique count of subjects having the particular AESOC.
如果一个病人相同的SOC下面有好几个不一样preferred term,那么这个病人的SOC
count 一次还
是好几次阿?
谢谢了 |
|
s*r
发帖数: 2757 | 32 你是count 人 还是count events
你要算%吧，那个分母是什么 |
|
j*********9
发帖数: 161 | 33 表达能力不太好，希望大家能看得懂。
n个variable代表n种疾病，1表示有病，“.”表示无此病。observation有3万多。
想最后得到一张n*n的表，能显示各种疾病的count以及任意两种疾病都有的count。我
用proc freq试了半天，能得到数据，就是不能弄成一张满意的表。
Help please！包子虽然不多，愿全部奉送！
|
|
j*********9
发帖数: 161 | 34 表达能力不太好，希望大家能看得懂。
n个variable代表n种疾病，1表示有病，“.”表示无此病。observation有3万多。
想最后得到一张n*n的表，能显示各种疾病的count以及任意两种疾病都有的count。我
用proc freq试了半天，能得到数据，就是不能弄成一张满意的表。
Help please！包子虽然不多，愿全部奉送！
|
|
c***i
发帖数: 45 | 35 There are some SAS procedures for panel count data. But, I cannot find one
that implements models for time series of count data, e.g. autoregressive
poisson model. |
|
i*********5
发帖数: 19210 | 36 http://lavamagazine.com/gear/70-3-worlds-bike-count/#axzz1XZexV
Results from the count that serves as a litmus test for the industry
Posted on September 11, 2011 by The Editors
Bikes
Cervelo: 351
Trek: 149
Felt: 118
Specialized: 116
Scott: 67
Components
Shimano: 1045
SRAM: 426
Campagnolo: 34
Wheels
Zipp: 1544
Hed: 275
Miscellaneous: 185
Mavic: 122
Reynolds: 108
Bontrager: 102
Tires
Continental: 639
Vittoria: 221
Michelin: 138
Zi... 阅读全帖 |
|
B*****g
发帖数: 34098 | 37 -- Hive queries for Word Count
drop table if exists doc;
-- 1) create table to load whole file
create table doc(
text string
) row format delimited fields terminated by 'n' stored as textfile;
--2) loads plain text file
--if file is .csv then in replace 'n' by ',' in step no 1 (creation of doc
table)
load data local inpath '/home/trendwise/Documents/sentiment/doc_data/
wikipedia' overwrite into table doc;
-- Trick-1
-- 3) wordCount in single line
SELECT word, COUNT(*) FROM doc LATERAL VIEW explo... 阅读全帖 |
|
|
|
|
|
|
|
|
w*******y
发帖数: 60932 | 45 Link:
http://www.dailycheckout.com/
Keep The Change
This is the ultimate in hi-tech piggy banks! Slip your change through the
coin slot and this jar electronically counts every coin, summing up the
total deposit and displaying the results on an easy-to-read LCD display. The
top lid twists off for easy access to your money. Ages 3 and up.
* Looking for a smart coin jar? You found it.
* This ingenious model electronically counts every coin as it slips thru
the slot.
* Then, sums up you |
|
|
|
|
|
|
