i****a
发帖数: 36252 | 1 select *
from TableA a
left outer join TableB b on a.id = b.id
where a.flag = 1
select *
from TableA a
left outer join TableB b on a.id = b.id
and a.flag = 1
结果是不一样的. 我还没有想明白为什么 |
|
c*****d
发帖数: 6045 | 2 简而言之，其实就是join和and的优先级问题
and的优先级高于join
select *
from TableA a
left outer join TableB b on a.id = b.id
and a.flag = 1
等价于
select *
from TableA a
left outer join TableB b on ( a.id = b.id and a.flag = 1 ) |
|
m******u
发帖数: 12400 | 3 table Weather（id，date， temperature）
question：find the day whose temperature is higher than its previous day (
yesterday).
Select w2.id, w2.date
from weather w1
left outer join weather w2
on w2.id = w1.id + 1
where w2.temp > w1.temp
看上去很别扭，这不像是left outer join，select clause 中没有一个是从left
table里来的。而且 join之后再select这个where condition到底怎么说？在join之后
的虚拟表中它们是在一行内的(如右图）
id date tem id date tem id date tem
1 1/1 2 1 1/1 2 2 ... 阅读全帖 |
|
f*******2
发帖数: 239 | 4 要求
有两个6万和4万的数据需要做full outer join 把两个表连到一个表里面去。
但是数据只是。csv文件，没有可以连的网络数据库
这样的情况，我可以用什么工具来做？
现在的尝试
1. Mysql workbench
下载了，但是最开始的一步就不行，没有数据库可以连上，所有的功能都不能用，当然
也没法import csv文件
求解释？
2. 下载了xampp 可以用phpmyadmin
但是，1，文件上次大小受限。按照网上的步骤修改了。出现的问题是，在写mysql
code的时候不能用full outer join，也不能用union all（left join+right join 然
后union all 去解决 full join 的问题）
查找了以上的问题，说是phpmyadmin 的版本bug，升级了版本后，居然连import都做不
了了。各种问题啊。。。
麻烦大神们指点。 |
|
f*******2
发帖数: 239 | 5 要求
有两个6万和4万的数据需要做full outer join 把两个表连到一个表里面去。
但是数据只是。csv文件，没有可以连的网络数据库
这样的情况，我可以用什么工具来做？
现在的尝试
1. Mysql workbench
下载了，但是最开始的一步就不行，没有数据库可以连上，所有的功能都不能用，当然
也没法import csv文件
求解释？
2. 下载了xampp 可以用phpmyadmin
但是，1，文件上次大小受限。按照网上的步骤修改了。出现的问题是，在写mysql
code的时候不能用full outer join，也不能用union all（left join+right join 然
后union all 去解决 full join 的问题）
查找了以上的问题，说是phpmyadmin 的版本bug，升级了版本后，居然连import都做不
了了。各种问题啊。。。
麻烦大神们指点。 |
|
c*****t
发帖数: 1879 | 6 No. You misunderstood what I was asking.
The issue at hand is not query optimization. But how to fetch
data efficiently. For instance, outer join let you retrieve
parent and child (assuming 1-1) in one single select statement.
However, if there are multiple children of the same type (1-many),
then such selection may not be efficient. Without outer join,
other approaches (without server component) would require multiple
selection statements.
This is a known issue for ORM tools. However, I ch |
|
r*****l
发帖数: 2859 | 7 First, you understanding of whether/how inner class accesses enclosing class
's private member is not correct. In your example, B is an inner class of A
and you said "class A and B will be independent". This is not right. In fact
B is a member (class) or A. You also mentioned "if we allow B to access A's
private variable, it is against encapsulation". This is again not correct.
Since B is A's member, it can access A's other private member.
Direct quote from oracle.com regarding inner class "A ne... 阅读全帖 |
|
r*****l
发帖数: 2859 | 8 I kept asking for your explanation on the following statement in your post.
"To make this happen, method local class has to keep copy of local
variables it refers"
The above statement is wrong. The reason I responded your post is to make is clear so that other people will not be confused.
I did do you a favor to compile your example. The results just showed the
opposite: after compilation, the inner class does not keep a copy. It just
hold a reference to access the outer class variable. If the o... 阅读全帖 |
|
g*****g
发帖数: 34805 | 9 这是我以前发过的帖子。
Basically there are 3 use cases of inner
class.
1. The class is simple and almost always created with the outer class, you
want a simple way to group these two classes. You can use a static public
inner class.
2. The class is never used outside of the outer class but you want to create
it in more than one places. private inner class is appropriate.
3. Same as 2 but you only need it in one place, anonymous inner class is
appropriate. |
|
F****n
发帖数: 3271 | 10 The real document is wrapped inside the outer class.
Only the outer class will be hard referenced during parsing.
~~~~~ Now you learn it can do more. |
|
g*****g
发帖数: 34805 | 11 This was not what I meant. Inner class is just inner class. Anonymous inner
class is just one of the kind. Basically there are 3 use cases of inner
class.
1. The class is simple and almost always created with the outer class, you
want a simple way to group these two classes. You can use a static public
inner class.
2. The class is never used outside of the outer class but you want to create
it in more than one places. private inner class is appropriate.
3. Same as 2 but you only need it in one p... 阅读全帖 |
|
i**p
发帖数: 902 | 12 We can use "new" for Java inner class like this:
Outer.Inner o = outer.new inner()
I don't remember C++ has the same usage. Is there any case we can use "new"
in C++ like that? |
|
T*******n
发帖数: 493 | 13 Marid loads the outer theme "infolines".
In beamerouterthemeinfolines.sty, on line 22, you will find the () that
you don't like.
So, make a copy of beamerthemeMadrid.sty and put it in your own directory
and change the name. Edit it and change the name of the outer theme on
line 19.
Copy beamerouterthemeinfolines.sty to your directory and rename it to
match what you use on line 19 in the above file. Edit line 22 and
remove the ().
Change your .tex file to load the new customized theme. |
|
r***o
发帖数: 1285 | 14 Explanation: Why does the Earth have a magnetic field? The electrical
conductivity of the molten plasma of the Earth's core should be able to
damp the current magnetic field in only thousands of years. Yet our five
billion year old Earth clearly causes magnets to point to (defined) north.
The mystery is still being studied but recently thought related to motions
in the Earth's liquid outer core. Specifically, as portions of the outer
core cool and fall inward, oceans of the liquid iron-rich magm |
|
s*****t
发帖数: 1994 | 15 M64: The Sleeping Beauty Galaxy
Credit: NASA and the Hubble Heritage Team (AURA/STScI), S. Smartt (IoA) & D. Richstone (U. Michigan) et al.
Explanation: The Sleeping Beauty galaxy may appear peaceful at first sight but it is actually tossing and turning. In an unexpected twist, recent observations have shown that the gas in the outer regions of this photogenic spiral is rotating in the
opposite direction from all of the stars! Collisions between gas in the inner and outer regions are creating ma |
|
s*****t
发帖数: 1994 | 16 The Cat's Eye Nebula from Hubble
Credit: NASA, ESA, HEIC, and The Hubble Heritage Team (STScI/AURA)
Explanation: Staring across interstellar space, the alluring Cat's Eye
nebula lies three thousand light-years from Earth. A classic planetary
nebula, the Cat's Eye (NGC 6543) represents a final, brief yet glorious
phase in the life of a sun-like star. This nebula's dying central star may
have produced the simple, outer pattern of dusty concentric shells by
shrugging off outer layers in a series of |
|
a*****y
发帖数: 277 | 17 You are right. When GFP is in the periplasm it is not folded properly.
However some outer membrane, when expressed recombinantly, can be in both
inner membrane and outer membrane, in which case you'll see GFP Fluorescence
.
There are certainly other fluorescent proteins - I can not remember the name
now. it is called something like ilov or ilove or ilike...? |
|
g*********d
发帖数: 233 | 18 The role of small non-coding RNAs in genome stability and chromatin
organization
http://jcs.biologists.org/content/123/11/1825.full
Josien C. van Wolfswinkel and René F. Ketting*
Journal of Cell Science 123, 1825-1839
© 2010. Published by The Company of Biologists Ltd
doi:10.1242/jcs.061713
Summary
Small non-coding RNAs make up much of the RNA content of a cell and have
the potential to regulate gene expression on many different levels.
Initial discoveries in the 1990s and early 21st centur... 阅读全帖 |
|
m*******r
发帖数: 7495 | 19 初中同学的大学同学得了Acute zonal occult outer retinopathy
(AZOOR)，一只眼睛面临失明。刚微信上给我发来这个图片，紧急询问国外治疗
情况。
这人目前在广州，去了当地最好医院，但国内缺乏治疗这个病的技术。
急问各位在医院的，是否对这个病在国外的治疗手段有所了解。任何信息请不
吝分享！
非常感谢！！！
【AZOOR: URGENT HELP NEEDED】 One of my friends unfortunately
has a unusual eye disease: Acute zonal occult outer
retinopathy (AZOOR). She is in early 30's, living in China.
Her right eye has been becoming almost blind. However, there
is no effective medical treatment for this disease in China.
Does anybody have any information f... 阅读全帖 |
|
l********s
发帖数: 358 | 20 在网上看到的这两个interview问题
1. You have three adjacent parallel metal lines. Two out of phase signals
pass through the outer two metal lines. Draw the waveforms in the center
metal line due to interference. Now, draw the signals if the signals in
outer metal lines are in phase with each other.
out of phase: center metal line没有signal
in phase: center metal line的signal是和两边的一致
我不知道这样对不对，这应该是Crosstalk的问题吧
2. What happens if we increase the number of contacts or via from one metal
layer to the next?
是两层之间的r |
|
l***g
发帖数: 1035 | 21 current is the inner loop. you can decide what to be the outer loop. that's
where you hookup the feedback to the threshold.
in that sense, vmode and imode are the same. you can compute the duty cycle
but you build the circuit by closing the outer loop and to adjust the refenc
e, not to fix a duty cycle.
cur
peak
in
设定
am |
|
b***8
发帖数: 15 | 22 The difficult thing for me is to close the control loop.
Peak mode current mode control. ( outer and inter control loop)
The error amplifier ( outer control loop) compensation design.
Any reference?
Thanks |
|
B****n
发帖数: 11290 | 23 1. Please give an example of a subset of [0,1] with outer measure 1 and inner
measure 0. (Use traditional lebesgue measure)
2. Please give an example that a sequence of arbitrary maps Tn:[0,1]->R is
decreasing to 0, |Tn|<=1 for all n, and E*Tn=1 where E*Tn is the outer
integral defined by inf{EU, U measureable and larger than Tn EU exists}' Here
is also lebesgue measure on [0,1].
This question is a about counter example of dominated convergence theorem for
arbitrary non-measurable maps with orin |
|
S*********g
发帖数: 5298 | 24 Suppose L1 and L2 are two n by n matrice
Outer[Times,L1,L2] gives the write result
Following is a test:
L1={{1,2},{3,4}}; L2={{1,2},{3,4}}
MatrixForm[Outer[Times, L1, L2]] |
|
s*****n
发帖数: 2174 | 25 第一个问题:
建立一个i的向量就可以了.
a <- c(2, 7, 8, 9)
b <- c(1, 1, 2, 3)
i <- 1:length(a)
t <- 0.2
a * t^b *(1 - t)^(i - b)
第二个问题:
用outer函数
比如 outer(b, b, "-") |
|
l***a
发帖数: 12410 | 26 in your case, no 作用. normally there is a "if" statement to realize left/
right /outer join
if aa; ->left join
if bb; ->right join
if aa or bb -> outer join |
|
b******e
发帖数: 228 | 27 请教两个SAS ADV问题，包子答谢！
下面这道题网上给的答案是A，但是A里给sum(Expense)的 label=’COST’ ，与结果的
‘Cost’不一致。个人认为答案应该是D，在sum(Expense) as Cost之后，data sets
VISIT1和VISIT2的columns with common names, 用outer union corr可以overlay the
columns。如有错误，请指正，非常感谢！
26. Given the following SAS data sets:
WORK.VISIT1 WORK.VISIT2
Id Expense Id Cost
— ——- — —-
001 500 001 300
001 400 002 600
003 350
The following result set wa... 阅读全帖 |
|
R*****d
发帖数: 420 | 28 我觉得用sql full outer join 也可以。
select a.col1, a.col2, b.col1, b.col2 from tableA a full outer join tableB b
on a.col1=b.col1; something like this.
sas sql should have it. |
|
P*****i
发帖数: 63 | 29 多谢解惑。
我现在明白了，开始只想着说一定不要有两列g3出现，指明一个就好。以为后面的full
join能把所有行cover.
现在我更加清楚coalesce这个选项的含义了---不仅是压缩同名行，而且还取全集。
自己做点笔记小结一下跟SAS的对比：
SAS里的match-merge语句，
data merged;
merge one two;
by x;
run;
效果等同于proc sql里的横向合并，具体情况又分：
当比对的by variable x全部匹配时，merge等同于inner join, 如果x只有部分值能匹配，那么等同于full outer join搭配coalesce选项；
SAS里的数据集拼接(concatenate)：
data three;
set one two;
run;
等同于proc sql里的纵向合并中的outer union corr. |
|
m*******r
发帖数: 7495 | 30 【 以下文字转载自 Biology 讨论区 】
发信人: moonpolar (处女+天秤=双子), 信区: Biology
标 题: 【紧急求助！！！】为一面临失明威胁的朋友求医
发信站: BBS 未名空间站 (Thu Jun 27 04:41:52 2013, 美东)
初中同学的大学同学得了Acute zonal occult outer retinopathy
(AZOOR)，一只眼睛面临失明。刚微信上给我发来这个图片，紧急询问国外治疗
情况。
这人目前在广州，去了当地最好医院，但国内缺乏治疗这个病的技术。
急问各位在医院的，是否对这个病在国外的治疗手段有所了解。任何信息请不
吝分享！
非常感谢！！！
【AZOOR: URGENT HELP NEEDED】 One of my friends unfortunately
has a unusual eye disease: Acute zonal occult outer
retinopathy (AZOOR). She is in early 30's, living in China.
Her right eye has b... 阅读全帖 |
|
v*****e
发帖数: 30 | 31 国内的好朋友最近诊断乳腺癌。她有一个年幼的孩子，真的很替她着急担心。最近化疗
两个疗程之后，白细胞下降得很厉害。这里附上她的诊断和问题，这里哪位好心的大侠
能给回答一下？ 她已经把问题翻译成了英文.
Specimen Type: Specimen of modified radical mastectomy right breast
Tumour Site/Location: 2.5 cm from the top of the nipple
Size of Tumour: 2.5 x 2.3 x 1.4 cm
Tumour Type: Mucinous carcinomas, ductal carcinoma in situ was seen around
the surrounding area (low and intermediate grade)
Histologic Grade: (blank)
Intravenous Tumor Thrombus: (+) Nerve Invasion: ( - )
Nipple: no cancer cell ... 阅读全帖 |
|
g*****d
发帖数: 991 | 32 来自主题: Medicalpractice版 - 运送遗体回国 不熟悉，但是，网上有这方面的信息，可以自己查找。
To ship a body from the United States to a foreign country:
1.The family you're serving should provide the name of the funeral home in
the receiving country, but always contact that firm personally to verify
that it will receive the body and that no other requirements are needed.
2.Embalm the remains according to U. S. standards.
3.Include the following:
a.Communicable Disease Affidavit.
6.Embalmers Affidavit (on your funeral home's letterhead). This item
explains the em... 阅读全帖 |
|
n***o
发帖数: 210 | 33 Rotor replace job for 92 accord. Damn hub-over-rotor design. I have
greeted Honda engineer's relatives many times.
Took two knuckles off without too much trouble, upper, lower and tie rod end
ball joints off easily. I found the reason the shaking when brake from 60
mph - both inner pads worn much worse than outer pads. On is almost down to
the wear indicator, while the outer pads has about 4-5 mm left. Besides,
the contact surface of the inner pads are just a stripe in the central part,
thi |
|
c*********r
发帖数: 19468 | 34 see panda's explanation
let's assume the outer wheel turns 10% faster on a certain corner than the
inner wheel
but with the torque vectoring device, it theoretically rotates 50% faster
however, it can't if the wheels still have good traction
that means it can only turn about 10% faster in the real world, ok?
so, inside the clutch, the side synchronized with the outer wheel actually
rotates SLOWER than the other side. so torque will be transfered from the
slower wheel (faster inside the clutch) t |
|
H*******d
发帖数: 2394 | 35 握手握手，也说一下我的吧。
01 93 （非SE） Manual
10年10月入手56k Mile，到现在快80k Mile
迄今为止换了/修了：
后轮刹车，
PCV6 Update，
火花塞，
Tranny Oil，
4条轮胎 + 一套rim，
AirFilter。
将要/可能发生的问题：
1.最近出现code： P1302 cylinder 2 misfire detected, catalyst damaging.（互换
1,2缸的火花塞并抹掉code后一个礼拜没亮灯，可昨天又闪了2,3秒）
有可能是Direct Ignition cartridge坏了（75%），或第二个火花塞坏了（25%）
2.后箱的支杆遇天冷就不行，气温高点可以撑住，暂时懒得换。
3.outer tie rod锈死了，没法调节alignment，虽然不怎么跑偏，但toe in的角度有点
过。需要同时换adjuster和outer tie rod。
4.手刹天冷容易冻住，就是停车一晚上到第二天早上松不掉，非要强行开一会才回
release。
5.右后门中控锁坏了，需要手动按下/拔起。
6.driver sid... 阅读全帖 |
|
t******7
发帖数: 396 | 36 it took nissan service tech about 3.5 hours and labor cost $140cash
left outer tie rod broken
right outer tie rod worn out
inner tie rod both very loose
front sway bar links both worn out
rear sway bar links both broken
front sway bar bushings worn out
rear sway bar bushings look ok
the oem lower control arms looks ok but need the new ones anyway because
it is lowered by eibach springs
rear shock bushings need special tools to take out, nissan service tech is
going to take my car on saturday to ... 阅读全帖 |
|
w*******y
发帖数: 60932 | 37 This is a great deal. They are usually $80.
Weight: 1.8 lb.
Fabric: 1000 denier Cordura outer shell, 18 oz. seam-sealed truck tarp liner
Product Source: Chico, CA, USA
Flat Dimensions: 18 wide, 12 high, 4 deep
Features:
* 1,000 denier weatherproof Cordura outer shell
* 18oz. weatherproof truck tarp inner liner
* Five bar seatbelt webbing strap
* Easily adjustable strap with nickel-plated tri-glide
* Nylon 69 thread and YKK zippers
* Cross-stabilizing strap around waist
|
|
r***o
发帖数: 1285 | 38 Explanation: Why does the Earth have a magnetic field? The electrical
conductivity of the molten plasma of the Earth's core should be able to
damp the current magnetic field in only thousands of years. Yet our five
billion year old Earth clearly causes magnets to point to (defined) north.
The mystery is still being studied but recently thought related to motions
in the Earth's liquid outer core. Specifically, as portions of the outer
core cool and fall inward, oceans of the liquid iron-rich magm |
|
s*****t
发帖数: 1994 | 39 M64: The Sleeping Beauty Galaxy
Credit: NASA and the Hubble Heritage Team (AURA/STScI), S. Smartt (IoA) & D. Richstone (U. Michigan) et al.
Explanation: The Sleeping Beauty galaxy may appear peaceful at first sight but it is actually tossing and turning. In an unexpected twist, recent observations have shown that the gas in the outer regions of this photogenic spiral is rotating in the
opposite direction from all of the stars! Collisions between gas in the inner and outer regions are creating ma |
|
s*****t
发帖数: 1994 | 40 The Cat's Eye Nebula from Hubble
Credit: NASA, ESA, HEIC, and The Hubble Heritage Team (STScI/AURA)
Explanation: Staring across interstellar space, the alluring Cat's Eye
nebula lies three thousand light-years from Earth. A classic planetary
nebula, the Cat's Eye (NGC 6543) represents a final, brief yet glorious
phase in the life of a sun-like star. This nebula's dying central star may
have produced the simple, outer pattern of dusty concentric shells by
shrugging off outer layers in a series of |
|
r***9
发帖数: 354 | 41 中华民国丢掉外蒙是苏美英中共四方共同促成,雅尔塔协议第一条就是蒙古人民共和国
的现状必须维持(The status quo in Outer-Mongolia (The Mongolian People's
Republic) shall be preserved;)，这是苏联斯大林主导，罗斯福邱吉尔出卖中国外蒙
换取苏联出兵东北和太平洋。美国当时原子弹还没试爆成功，手里的底牌少，和斯大林
打交道赔大发了。
国共内战国军失败的原因往深处挖掘很有意思，国民政府的腐败是一方面，美国袖手旁
观任由国民政府垮台才是主因，1945-1949年美国是世界上唯一拥有原子弹的国家，灭
掉苏联和整个欧洲都没问题，30多万驻日美军近在咫尺，还能打不过中共？还找国民党
腐败的烂理由，美国在二战期间和国民党政府打了多少交道，不知道国民政府有腐败?
唯一的解释就是美国不希望出现一个和他块头一样大，民主制度一样好的东方大国，苏
俄都知道分裂外蒙削弱中国就怕的是中国早晚做大反噬，美国人当然更清楚，一个小日
本换装民主制度30多年就成世界第二了，一个自由民主的中国对美国意味着什么呢,所
以美国任由中国滑入共产主义深渊 |
|
|
c*********s
发帖数: 85 | 43 If 北方语言 mostly means mandarin chinese, the no brainer explanation is
that it's the dialect of chinese that the Manchu spoke then forced upon the
territory under their control either directly or indirectly. The effect
would naturally radiate out from their power base as fewer Manchu officials
go that far out to maintain control on the territory.
Going farther back in time, the power base of the preceding dynasties has
centered on beijing for a LOT of years (even the center like 陕西 was pretty
"nor... 阅读全帖 |
|
|
c**i
发帖数: 6973 | 45 (1) Steve Denning, Scalable Collaboration: Lessons From China: Li & Fung.
Forbes, Oct 8, 2011
http://www.forbes.com/sites/stevedenning
/2011/10/08/scalable-collaboration-lessons-from-china-li-fung/
("Li & Fung owns practically nothing. Its role is to figure out a way to
orchestrate factories")
Note:
(a) FUNG Pak-liu 冯柏燎 and LI To-ming 李道明 founded Li & Fung 利豐公司 in
Canton/ Guangzhou in 1906. The company relocated to Hong Kong in 1949. See
Li & Fung Group
http://www.lifunggroup.com/eng/global/home... 阅读全帖 |
|
f**d
发帖数: 768 | 46 ScienceDaily (May 2, 2011) — In 2005, researchers from the University
of North Carolina at Chapel Hill found that 2-year-old children with
autism have brains up to 10 percent larger than children of the same age
without autism.
Now a follow-up study by UNC researchers has found that the children who
had enlarged brains at age 2 continued to have enlarged brains at
ages 4 and 5, but the amount of the enlargement was to the same degree
found at age 2. This increased brain growth did not continue b... 阅读全帖 |
|
y***y
发帖数: 198 | 47 ☆─────────────────────────────────────☆
sociliyi (李毅) 于 (Wed Sep 9 15:39:49 2009, 美东) 提到:
Yalta Agreement
Signed at Yalta, February 11, 1945
The leaders of the three Great Powers-the Soviet Union, the United States of
America and Great Britain-have agreed that in two or three months after
Germany has surrendered and the war in Europe has terminated the Soviet
Union shall enter into the war against Japan on the side of the Allies on
condition that :
The status quo in Outer-Mongolia (The Mon |
|
|
n*******4
发帖数: 2285 | 49 这是Nova的一集。
http://www.pbs.org/wgbh/nova/transcripts/3412_samurai.html
RICHARD VINCI: When the smith plunges it into water, the two different parts
of the sword are both contracting. The part with low carbon—this is the
part inside the core of the blade—is able to contract pretty much like it
would like to, because there's really not much carbon in there to be trapped
. So it shrinks a lot. The part on the outer surface though, is filled with
carbon, and so it's really prevented from shrinking as... 阅读全帖 |
|
w********s
发帖数: 343 | 50 1914-1950期间最重要的也是唯独涉及西藏法律地位的条约就是1914's Simla Accord（
注意：并不是条约, for UK recognized China’s suzerainty till 1987 when it
virtually recognized China’s sovereignty）。
如按条约执行，民国政府可以在外藏(Outer Tibet)派员，扈随定员300人。按英印当局
的一贯逻辑，他们也会派特使往返拉萨，特使的扈随定员为中方的75%。 而且一旦有中
方存在，那么40年代的南亚独立运动可能会唤醒西藏人的独立意识。
妙就妙在民国来了个不作为，只是吸收上层入国大。 |
|
