l******9 发帖数: 579 | 1 【 以下文字转载自 Database 讨论区 】
发信人: light009 (light009), 信区: Database
标 题: SQL find distinct values in large table
发信站: BBS 未名空间站 (Wed May 21 17:20:16 2014, 美东)
I have a very large table with 1 billion rows and 12 columns, which are int,
double, varchar. I need to know the distinct values for each volume.
the table has columns :
id id_1 id_2 id_3 id_4 id_5 id_6 id_7 id_8 id_9 id_10 id_11
SELECT COUNT(distinct a.id) as num_dist_id
FROM my_large_table as a
SELECT distinct a.id
FR... 阅读全帖 |
|
T*******e 发帖数: 4928 | 2 Are you sure it's working? For example,
Find the 4th element in 6x6 matrix.
matrix:
1 20 30 40 50 60
2 21 31 41 51 61
3 22 32 42 52 62
4 23 33 43 53 63
5 24 34 44 54 64
6 25 35 45 55 65 |
|
T*******e 发帖数: 4928 | 3 Are you sure it's working? For example,
Find the 4th element in 6x6 matrix.
matrix:
1 20 30 40 50 60
2 21 31 41 51 61
3 22 32 42 52 62
4 23 33 43 53 63
5 24 34 44 54 64
6 25 35 45 55 65 |
|
w*****1 发帖数: 151 | 4 【 以下文字转载自 Military 讨论区 】
发信人: wsmj001 (wsmj), 信区: Military
标 题: 老中讨好白人的最恶心的话: why not find a Chinese girl friend?
发信站: BBS 未名空间站 (Tue Aug 19 00:18:06 2014, 美东)
我每次看到叫做什么John,David,Michael的猥琐男的老中同事讨好白人时候说这种话
, 我就觉得这个家伙是在说来操我妈, 操我姐姐操我妹妹吧。
我真的是为他是一个中国人感到丢脸。 |
|
|
f********c 发帖数: 147 | 6 题目:Given a file containing all possible numbers on a 32-bit architecture,
4 numbers are missing. Find the 4 missing numbers.
想了半天不知道该怎么入手,求高手解答下,谢谢了 |
|
J*****n 发帖数: 137 | 7 find peak 和 local maximum 是一样的吧?有问到 local minimum?这道题就考
binary search吧?你怀疑有坑? |
|
f******5 发帖数: 104 | 8 BST, O (n*(logW+k))
void printBST(multiset > &BST, int k){
int i=0;
multiset >::iterator it=BST.begin();
for(;i
cout<<(*it)<<",";
++it;
}
cout<
}
void topK_SlideWindow(vector &A, int w, int k){
//use BST tree to record w elems in the windows.
//update BST, add new elem into BST, and delete old elem.
assert(A.size()>=w&&k<=w);
multiset >BST;
for(int i=0;i
... 阅读全帖 |
|
S*******C 发帖数: 822 | 9 find union and intersection for 2 arrays without using sets/other data
structure
难道只能先对较长的array排序,再对另一个array中的元素用binary search一一查询
?有没有更好的方法? |
|
H******7 发帖数: 1728 | 10 find top K most occurring words in streaming data 这题怎么做比较好 |
|
|
s**x 发帖数: 7506 | 12
stack
关键是 heap is not the right data structure for this. yeah, you can insert
in logN and find min in O(1), but it is tricky to remove one element out of
the window. you have to have some sort of index to the position in the
heap from the position in the sliding window. far worse than a queue, or
circular buffer, or even stack etc. |
|
|
v*******g 发帖数: 1 | 14 Hi there,
My parents come here to visit us. Now my mom want to find a baby to take
care during her staying period. We live in UC Riverside family house. My mom
is clean, loving Chinese lady who has experience of taking care of children.
Please send me an email if you are intereted. V***********[email protected]
Thanks.
Vivi |
|
s********2 发帖数: 1 | 15 i am not lucky, lose stipend and my Toefle is outdated, and do not want to
transfer to other major recently. so i want to prepare for PCAT and apply
2008, so how can i find a job here? |
|
k***t 发帖数: 769 | 16 I want find a part-time job in summer vacation.I am good at cooking and I
can smoothly talk with people use english. Please contact with me. |
|
f********m 发帖数: 21 | 17 帮朋友转发:
NP-World Inc. http://www.np-world.com is a US-based international hiring site that provides a platform for people around the globe to find and fill part-time or full-time, bi-lingual or multi-lingual positions. Our quality team reviews every job posting to weed out inappropriate posts or scams to ensure the best experience of the applicants. Jobs on the site are related to travel, business. Some are remote positions that require special skills such as programming, language, law, consulti |
|
l****2 发帖数: 3 | 18 Hello, everyone,
I live in Ann Arbor, Michigan. I have bachelor degree in accounting and have
about 8 years experience in China, but I have no experience in US. I have
Green Card.I have looked for a job for a month, but no response. Please tell
me how to find an accounting job and introduce some website. Thank you so
much. |
|
k***a 发帖数: 22 | 19 Internship, in a sense, is harder to find than full time job, since most
well established companies are not cutting off full time jobs, and their
expectation for internship program drops significantly in last 3 months.
Here are a few ways you can try:
1. Write to your alumni, but do not ask for internship, but for advice.
The first is to establish communications and some alumni really can provide
good insight on their internal potential internship after they know you
better.
2. Network or write |
|
w*****c 发帖数: 2 | 20 Can anyone please tell me how can I find a recruitment consultant who can
get
me a job nearby San Jose? Thanks a lot. |
|
L***z 发帖数: 454 | 21 I've heard lots of people talking about new houses priced at 300k or below.
I am curious as to what kind of materials they use and why they could be so
cheap.
I've renovated several houses here in mid-atlantic area. One of the most
recent, about 100 years old, cost me about 200k+ for renovation. This is the
lowest price I can find--most other contractors ask for around 300k.
I did not use very fancy materials (of course, the materials in general
would be better than most big builders such as Tol |
|
h****a 发帖数: 628 | 22 how to find out house info about 有没有掩埋什么废旧化学原料、核原料、放射或
者辐射性很强的
原料? |
|
j****l 发帖数: 687 | 23 As the old saw goes, money doesn't grow on trees. But sometimes it sprouts
up in the garden. An unemployed man in northern Illinois was out working in
his backyard when he came across some serious green: bags filled with $150,
000 cash.
Wayne Sabaj was headed to pick some broccoli to go with his roast. The
carpenter spotted duffel bags that looked like trash by the peppers -- but
they turned out to be a cash crop: stacks of $20 bills that added up to
about $150,000. The 49-year-old, who is livin... 阅读全帖 |
|
d*c 发帖数: 306 | 24 buy a short sale, have concern about unrecorded lien, want to buy an owner's
title policy to cover unrecorded lien, but couldn't find. |
|
c******e 发帖数: 350 | 25 We're thinking of a house close to a rail track.
We wonder how often and when trains pass by.
Hopefully it's not at night when we need good rest.
Anyone knows where to find the information?
My agent said he didn't know either.
Thanks a lot! |
|
m*******i 发帖数: 370 | 26 Sorry I cannot type Chinese.
I just bought a house and the kitchen is partially finished. I plan to
expand the cabinet the kitchen currently have to have more counter tops. I
have talked to several kitchen remodel contractors. All of them suggest me
to ask the seller for the original maker of the cabinet since they cannot
produce the exactly same cabinet for me. Problem is the seller told me he
cannot remember the original maker for these cabinets :( I only know the
cabinet made of cherry wood. ... 阅读全帖 |
|
m*******i 发帖数: 370 | 27 I tried several cabinet doors, but didn't find anything, I will search all
of them tonight...
Yumen a !
Any other ways? |
|
m*******i 发帖数: 370 | 28 problem is several contractors I talked with told me they cannot produce the
exact same cabinet.
Where/how I can find the cabinet maker to produce the same cabinet for me ? |
|
w*******7 发帖数: 89 | 29 My coleage's father need specialist in periodontics and implants, don't know
where to find good ones in NJ. Thanks! |
|
r*****6 发帖数: 5063 | 30 after I log in to AMEX account, I cannot find secure message->memebership
awards->program info and
definitions.
Which tab is secure message under? Baozi to thank you. |
|
j*******n 发帖数: 2205 | 31 I checked there is no saver AA tickets available for July 2015.
Is any chance to find or need wait AA releasing?
Thanks |
|
s****h 发帖数: 3979 | 32 OLD blue cash, how to find the 5% limit, and track the qualified amount YTD?
Thanks. |
|
s****h 发帖数: 3979 | 33 can't find YTD number in the statement.
Neither the 50K limit |
|
G*****5 发帖数: 30 | 34 Hello sisters,
I'm a stay at home mom. I would like to find 1 or 2 playmates for my 8 month
old baby boy so that babies can play together and moms can chat a little
bit. I live in Chicago. If you are interested, please reply. Thanks! By the
way, could you recommend a good pediatrician in Chicago area? Thanks a lot!
Sorry for not typing Chinese. I'm not a fast typist:( |
|
y**1 发帖数: 1037 | 35 We already sent our son to daycare, he seems enjoying daycare.So I dont
really want to pull him out from daycare. Bcs things go well with daycare.
but he is a very poor sleeper in the night, which made me so tired.(I
am carrying second baby now) I was wondering if I can find someone stay in
our house, cook dinner for us and takes care of my son for the night and
weekends? Is that impossible? I dont know how much I should pay ? and i dont
know if someone wants to do this kind of job? ... 阅读全帖 |
|
b**********y 发帖数: 112 | 36 Does anybody know where I can find Enfamil coupons?
Thanks. |
|
S*****m 发帖数: 293 | 37 多谢大家的祝福!
我不太清楚大B超的意思,感觉19-20周做的比较详细的B超好像就是。
刚刚医生发了个fact sheets,这两个term原来是 "Choroid plexus cysts"和“
Echogenic bowel",有没有jm了解这两个abnormal findings?
再次谢谢! |
|
b********8 发帖数: 83 | 38 谢谢楼主mm的解释。其实我比较迷糊,不是很清楚b超结果有多少abnormal findings。
医生只是说看到亮点,我也不知道怎么回事,就做了那个maternit21的测试。后来看了
mm的贴子才猜想可能是echogenic bowel。
现在等结果,要8-10天。和楼主一起加油,希望我们的测试结果都是好的。只要我们有
信心,宝宝一定会健健康康的!
soft
★ 发自iPhone App: ChineseWeb 7.7 |
|
b********8 发帖数: 83 | 39 1/16日做的大b超。1/18日医生打电话来说,b超上有abnormal finding,肠子附近发现
许多很亮的白点。要求马上去做基因测试。医生推荐做MaterniT21测试。据说是一种新
技术,准确率和羊水穿刺一样,但是只要验血即可。结果大约8-10天出来。我看病的诊
所是第一次order这样的测试,样品要寄到加州测试。
两周后,也就是上周四,我打电话去诊所,告诉我结果还没出。上周五,去看医生,医
生说已经两周了,结果应该出来了,让秘书打电话去lab问。lab customer support说
他们没有confirmation code,不能透露任何信息,更别说是否有结果。然后说
confirmation code应该是health department给诊所,并且给他们(lab),但是现在他
们也没有拿到这个confirmation code。诊所的秘书说完全不知道有这个confirmation
code的存在,并且告诉我们他们已经按照程序fax我的信息到health department。但是
没有收到过health department的response。因为已经是周五下午... 阅读全帖 |
|
B******1 发帖数: 9094 | 40 It appears that learning music can help a person speak.
By RANDOLPH E. SCHMID, AP Science Writer Randolph E. Schmid, Ap Science
Writer – Sat Feb 20, 4:35 pm ET
SAN DIEGO – Words and music, such natural partners that it seems obvious
they go together. Now science is confirming that those abilities are linked
in the brain, a finding that might even lead to better stroke treatments.
Studies have found overlap in the brain's processing of language and
instrumental music, and new research suggests th |
|
a*****g 发帖数: 19398 | 41 【 以下文字转载自 Go 讨论区 】
发信人: ananpig (●○ 围棋数学一把抓的安安猪), 信区: Go
标 题: Happy year year and find your best move in 2016
发信站: BBS 未名空间站 (Fri Jan 1 01:40:03 2016, 美东)
(如果看不出谁先行,就提示黑先行。) |
|
c*****9 发帖数: 2739 | 42 Where can I find the $2 Huggies Wpies coupon? |
|
m****n 发帖数: 2415 | 43 I can't find it in several store. Do any NYC store carry this item?Thanks, |
|
s*********6 发帖数: 549 | 44 vvq can't open it for my MAC computer! I can't find MAC flashget version to
download. What i can do now? |
|
g***t 发帖数: 83 | 45 Do they sit with other hand soaps or it has it's own display? I looked at
the soap aisle and body wash aisle, and didn't find it. |
|
P****o 发帖数: 26 | 46 Check out adBee (Grocery) in Android Market...
Some of my friends made it, you can use it to find weekly special from your
local grocery stores.
I tried and think it is quite useful. Recommend you guys to check it out and
give a try.
Their service is quite limited now, but it is useful if you happen to have
those stores near your home... |
|
y********n 发帖数: 1669 | 47 I can't find it anywhere. |
|
h******x 发帖数: 10156 | 48 【 以下文字转载自 ebiz 讨论区 】
发信人: happylux (mike), 信区: ebiz
标 题: How to find the best home equity loan?
发信站: BBS 未名空间站 (Wed Sep 15 07:52:04 2010, 美东)
各位的home equity loan利率是多少?怎么找的?
对了,忘了说套话:万能的ebiz,blabla。。。 |
|
y******4 发帖数: 322 | 49 I want to buy L'orea . There is some coupon on Sunday's Paper. Where can I
find it? THanks |
|
h*********e 发帖数: 168 | 50 Don't have sams club membership. Have costco.:(
Last week cvs buy 75 iTunes get 20 back.Should buy it.
I checked walgreens web, didn't find any deal. |
|