Q********g
发帖数: 2465 | 1 So? Revenue increase is the key, lol
Don't be fooled by the craps... hold share
: more clicks.
: Aggregate paid clicks were up 52% on the year and 12% on the prior
quarter.
: Aggregate cost-per-click was down 23% on the year and down 6% on the
quarter.
: ：If pay per click drops 23%, how goog managed revenue increase of 28%?
: ：【 在 bigwatergun(帝都旧事) 的大作中提到: 】
: ： |
|
w***z
发帖数: 209 | 2 请高手帮忙解读一下，我看到301.6114-1中有这样一条
Reporting is waived for an individual if payments or income items otherwise
reportable under this section (other than by reason of paragraph (b)(8) of
this section), received by the individual during the course of the taxable
year do not exceed $10,000 in the aggregate or, in the case of payments or
income items reportable only by reason of paragraph (b)(8) of this section,
do not exceed $100,000 in the aggregate.
是不是意味着我们可以豁免不用填8843了？因为我们只有5000块用treaty了。 |
|
s******g
发帖数: 654 | 3 Good boy.
Foreign accounts and assets. As if U.S. taxpayers with foreign accounts and
assets did not already have enough cause for confusion regarding the filing
requirements for Form TD F 90-22.1, Report of Foreign Bank and Financial
Accounts (FBAR), FATCA now imposes a second filing requirement on them.
Section 511 of FATCA creates new IRC § 6038D, which requires U.S. taxpayers
with foreign accounts and assets with an aggregate value exceeding $50,000
to report them on an informational return.... 阅读全帖 |
|
Z*****l
发帖数: 14069 | 4 bless. better check with a lawyer.
i think
1. yr opt is still effective for 120 days.
2. next company must be e-verify.
3. yes, you can use the opt for new job.
4. you are legal for 120 days.
reference
http://oisss.unc.edu/students/f1/MOUstem10-08.pdf
Periods of unemployment during post-completion OPT: I understand I may not
accrue more than an aggregate of
90 days of unemployment during the initial 12-month OPT period. If I am
approved for the 17-month STEM extension,
an additional 30 days of u... 阅读全帖 |
|
f********i
发帖数: 577 | 5 1 我有IEEE top journal paper 3 个。一作2个。 top conference 论文7 篇。
The aggregate total of citations to your English papers. is: 119 including
IEEE Transaction/journal and IEEE conference
The aggregate total of citations to your first authored English papers: 77
including IEEE Transaction/journal and IEEE conference
2 获过 IEEE society大奖。 每年从300个top journal paper中选3篇作为best prize
paper award
3. review过近20篇top journal paper.现在还在很快的速度review更多transaction
paper. （the journal papers I reviewed: 20+ The confere... 阅读全帖 |
|
l**n
发帖数: 908 | 6 JCR能上不？
按这个步骤：
1. 选择View a group of journals by Subject Category
2. 选择你想要查找的categories（用Ctrl来选择两个以上的category）
3. 按Submit键，所有属于你选择的category的journal都会出现，你可以让它们按名称
、If 、5-year IF、eigenscore factor、total citation等进行排序（不过与你想要
median/aggregate IF的东西无关）
4. 按顶上welcome help下面那一排的那个”view category summary list“你就会看
到所有你选择的category的median 和 aggregate IF |
|
b****n
发帖数: 379 | 7 本来就是弱case一个，虽然使劲攒人品share review，但还是被RFE。大家给出出主意
，还不想卷铺盖。
Claim了一下3条，条条被RFE,不活了！
1. Judging the work of others:
The evidence you submitted is insufficient. You have provided evidence that
appears to meet the plain language of this criterion; however, the evidence
of record must still, in the aggregate, establish that the beneficiary is an
"alien of extraordinary ability."
审了五六十篇稿子，就是杂志（化学方面）影响因子最高才4.8两次，4.0四五次。不知
道是否这个原因觉得我没有extraordinary。
2.Original Contributions:
The evidence you submitted is i... 阅读全帖 |
|
y*****o
发帖数: 2364 | 8 April 3, 2016
USCIS
Attn: I-140
2501 S. State Highway 121 Business
Suite 400
Lewisville, TX 75067
RE: EB-1 Petition for Permanent Residency under the category of Alien of
Extraordinary Ability
Petitioner/Beneficiary: XXX YANG, Ph.D.
Classification Sought: 203(b)(1)(A)
Type of Petition: I-140
Dear Immigration Officer:
This letter is respectfully submitted in support of Dr. XXX Yang’s petition
for classification as a qualified immigrant under the first p... 阅读全帖 |
|
l**7
发帖数: 3940 | 9
\ slb \ SERVICE LAW BOOKS MENU \ IMMIGRATION AND NATIONALITY ACT \ INA: ACT
203 - ALLOCATION OF IMMIGRANT VISAS
Previous Document Next Document
INA: ACT 203 - ALLOCATION OF IMMIGRANT VISAS
Sec. 203. [8 U.S.C. 1153]
(a) Preference Allocation for Family-Sponsored Immigrants. - Aliens subject
to the worldwide level specified in section 201(c) for family-sponsored
immigrants shall be allotted visas as follows:
(1) Unmarried sons and daughters of citizens. - Qualified immigrants who are
t... 阅读全帖 |
|
|
|
c*******h
发帖数: 107 | 12 For fiscal year 2012, 15 percent of the immigrant visas made available under
each of paragraphs (2) and (3) of section 203(b) of such Act (8 U.S.C. 1153
(b)) shall be allotted to immigrants who are natives of a foreign state or
dependent area that was not one of the two states with the largest aggregate
numbers of natives obtaining immigrant visas during fiscal year 2010 under
such paragraphs.
什么叫 “the two states with the largest aggregate numbers of natives
obtaining immigrant visas during fisc... 阅读全帖 |
|
m*******l
发帖数: 12782 | 13 ☆─────────────────────────────────────☆
Stevens009 (Stevens009) 于 (Wed Oct 12 15:53:51 2011, 美东) 提到:
3012 这个bill烙印的70%不分EB1 EB2 EB3吗？那通过的话EB2C是不是也完蛋了？请高
人指点呀？
☆─────────────────────────────────────☆
alexx (panda in love~八胖~饲羊员~水木十年) 于 (Wed Oct 12 15:54:55 2011, 美东) 提到:
不会。俺不会完蛋。
☆─────────────────────────────────────☆
coolaladdin (我喜欢油灯和戒指) 于 (Wed Oct 12 15:56:33 2011, 美东) 提到:
category还是存在的，你说的情况不会发生。
☆─────────────────────────────────────☆
Stevens009 (Stevens009) 于 (Wed Oct ... 阅读全帖 |
|
l*******o
发帖数: 2795 | 14 这个新提案增加两个新类别eb-6 and eb-7
给大家贴出来。
House to Resurrect STEM Bill During Lame-Duck
Republican Leadership in the U.S. House of Representatives announced last
week its intention to take up STEM legislation introduced by Judiciary
Chairman Lamar Smith (R-TX) during the lame-duck session. (CQ Today, Nov.
13, 2012) The bill, H.R. 6429, eliminates the visa lottery by reallocating
the 55,000 green cards available under the program to two new employment-
based visa categories, the EB-6 and EB-7. (See H.R.... 阅读全帖 |
|
y******i
发帖数: 558 | 15 http://www.govtrack.us/congress/bills/112/hr6429/text
(7)(A)(ii)
agree to work for a total of not less than 5 years in the aggregate for the
petitioning employer or in the United States in a field of science,
technology, engineering, or mathematics upon being lawfully admitted for
permanent residence;
(agree to work) 并不一定要工作满，你同意工作满5年（还是aggregate，也就是说中
间可以中断）
(or in the United States) |
|
f**u
发帖数: 2769 | 16
只有EB2和EB3，而且是这两个加一起算。法案是这么说的：
For fiscal year 2013, 15 percent of the immigrant visas made available under
each of paragraphs (2) and (3) of section 203(b) of such Act (8 U.S.C. 1153
(b)) shall be allotted to immigrants who are natives of a foreign state or
dependent area that was not one of the two states with the largest aggregate
numbers of natives obtaining immigrant visas during fiscal year 2011 under
such paragraphs.
"aggregate numbers of ... under such paragraphs"
such paragraphs 应该是指 pa... 阅读全帖 |
|
o****c
发帖数: 511 | 17 opt延期可以有1个月没工作。 opt期间是3个月。可以累计4个月/120天。
(E) Periods of unemployment during post-completion OPT . During post
-completion OPT, F-1 status is dependent upon employment. Students may not
accrue an aggregate of more than 90 days of unemployment during any post-
completion OPT carried out under the initial post-completion OPT
authorization. Students granted a 17-month OPT extension may not accrue an
aggregate of more than 120 days of unemployment during the total OPT period
comprising any pos... 阅读全帖 |
|
G****a
发帖数: 10208 | 18 原创作者: daisychan (月色)
整理归纳， 老盖
今年整理电脑里的照片，想起很多以前的事。大概身边没有人会想到，不到24岁，外表
文静，在读理工PhD的我，内心是那么的狂热：初夜17岁，交往过7个男友。
(1)
我的性启蒙是初中的时候读言情小说，席绢，琼瑶。肉欲的场景的描写虽然隐晦，
每每看得我很湿。那时开始，我经常对着镜子看自己的身体，揉捏，想象着被一个男人
拥抱，亲吻，揉捏和占有的感觉。
(2)
我的第一个男人A是我的高中同学，我是班上的数学科代表，但他数学一直都比我好，
那时的我，就喜欢smart的男孩。周末的时候，我们有时会相约一起在图书馆做功课，
慢慢地，就变成去看电影，逛街。有一次，在电影院里，他牵了我的手，吻了我的额头
，officially我成为了他的女友，那时我16岁。
那时的我们，欲望热烈，在树林里kiss一个小时，也不会腻，我很enjoy他温暖的舌头
，和他那顶着我炽热的下身的硬棍。每次回到家，我的底裤基本都湿了。
有一次，父母不在家，他来我家做功课。做着做着，我就坐在他的腿上开始吻他的脖子
。他隐隐地发出一些呻吟，第一次把手伸进了我的裙子。当他碰到我湿... 阅读全帖 |
|
c**i
发帖数: 6973 | 19 You do not cite any authority.
And what you say is WRONG.
FinCEN-105: Report of International Transportation of Currency or Monetary
Instruments (31 USC 5316; 31 CFR 1010.340 and 1010.306).
http://www.fincen.gov/forms/files/fin105_cmir.pdf
Note; FinCEN stands for Financial Crimes Enforcement Network, US Department
of Treasury.
http://www.fincen.gov/
Quote: "GENERAL INSTRUCTIONS * * *
WHO MUST FILE:
(1) Each person who physically transports, mails, or ships, or causes to be
physically transported... 阅读全帖 |
|
d******1
发帖数: 349 | 20 会议脚本，很长，形势不乐观啊
Qualcomm Incorporated (NASDAQ:QCOM)
Q2 2015 Earnings Conference Call
April 22, 2015 04:45 PM ET
Executives
Warren Kneeshaw - Vice President, Investor Relations
Steve Mollenkopf - Chief Executive Officer
Derek Aberle - President
George Davis - Executive Vice President and Chief Financial Officer
Analysts
Tim Long - BMO Capital Markets
Mike Walkley - Canaccord Genuity
Ehud Gelblum - Citigroup
Blaine Curtis - Barclays
Kulbinder Garcha - Credit Suisse
Stacy Rasgon - Bernstein
James Fa... 阅读全帖 |
|
o******l
发帖数: 38 | 21 对求职网站和工具的一个总结
一、职位搜索网站
1. Jobguideweb.com
此网站将Indeed和Simplyhired上的信息综合在一起，可以叫做advanced aggregator,
用户可以在首页直接点击感兴趣的职位，尤其适合IT, engineering, web, finance等行
业。此网站还提供了用户讨论和图书推荐功能，可以在上面提问、交流经验和购书。
2. Indeed.com, simplyhired.com
这两个网站都是Job Search Aggregator, 将来自众多企业网站和招聘网站的信息综合
在一起，信息比较全面。但也不是万全的，有的小公司或者小网站上的信息就不能被这
两家
搜到。
3. Monster, careerbuilder, hotjobs
这就是传统的三大网站，不过已经是日趋衰落了，recruiting agency发布的信息的比
例越来越高，这些机会大多是Contract. 但是这三个网站投递简历还是比较方便，在上
面发布
简历也有机会被Recruiter找到，但要经常update。
4. Linkedi... 阅读全帖 |
|
t***h
发帖数: 5601 | 22 http://www.nytimes.com/2011/08/15/opinion/stop-coddling-the-sup
Stop Coddling the Super-Rich
By WARREN E. BUFFETT, Published: August 14, 2011
OUR leaders have asked for "shared sacrifice". But when they did the asking,
they spared me. I checked with my mega-rich friends to learn what pain they
were expecting. They, too, were left untouched.
While the poor and middle class fight for us in Afghanistan, and while most
Americans struggle to make ends meet, we mega-rich continue to get our
extraordin... 阅读全帖 |
|
|
s*******s
发帖数: 9926 | 24 还是San Francisco Bay Area硅谷高科技工作机会多很多
根据National Venture Capital Association的Regional Aggregate Data統計資料
2014年前半年整个西北创投金额仅是硅谷的19分之一
差19倍 两这其实根本不能相提并论
Seattle老是想来攀比湾区 但实际真的差的很远
工作机会的多寡对老中真的很重要
所以建议不要再来自取其辱了
https://www.pwcmoneytree.com/
选Regional Aggregate Data会有个Excel档 |
|
s*******s
发帖数: 9926 | 25 还是San Francisco Bay Area硅谷高科技工作机会多很多
根据National Venture Capital Association的Regional Aggregate Data統計資料
2014年前半年整个西北创投金额仅是硅谷的19分之一
差19倍 两这其实根本不能相提并论
Seattle老是想来攀比湾区 但实际真的差的很远
工作机会的多寡对老中真的很重要
所以建议不要再来自取其辱了
https://www.pwcmoneytree.com/
选Regional Aggregate Data会有个Excel档 |
|
s*******s
发帖数: 9926 | 26 还是San Francisco Bay Area硅谷高科技工作机会多很多
根据National Venture Capital Association的Regional Aggregate Data統計資料
2014年前半年整个西北创投金额仅是硅谷的19分之一
差19倍 两这其实根本不能相提并论
Seattle老是想来攀比湾区 但实际真的差的很远
工作机会的多寡对老中真的很重要
所以建议不要再来自取其辱了
https://www.pwcmoneytree.com/
选Regional Aggregate Data会有个Excel档 |
|
s**9
发帖数: 1649 | 27 关于带走鱼的limit
Daily-5 in aggregate
Possession -10 in aggregate
What does possession mean? |
|
b*****t
发帖数: 1930 | 28 Man Utd vs Barcelona:
07/03/84 - Nou Camp - Barcelona 2 - 0 United - 70,000 (A disappointing night
from what I've been told)
21/03/84 - Old Trafford - United 3 - 0 Barcelona - 58,574 (Robobo leading a
storming fight back from the first leg, United winning 3-2 on aggregate)
15/05/91 - Feyenoord Stadion - United 2 - 1 Barcelona - 50,000 (Mark Hughes'
night, two excellent goals)
19/10/94 - Old Trafford - United 2 - 2 Barcelona - 40,064 (Mark Hughes and
Lee Sharpe on target)
02/11/94 - Nou Camp - Ba... 阅读全帖 |
|
g******t
发帖数: 18158 | 29 两场aggregate的比分和单场是两回事，时间加了一倍呢
两场aggregate7：0和瓜没有关系，和鸟也没有关系，瓜带对打过拜人单场4：0，而且
是上半场就4：0，拜人可以说某种程度上报了一箭之仇，虽然瓜当时已经离开巴萨了
5：0也是两场aggregate，而且和鸟没有任何关系
胜败兵家常事，输了可以从头再来，安胖也不止一次被人逆转过。不过怎么令也不能说
鸟赢了瓜啊，你灌水不能纯靠脸皮啊 |
|
W********m
发帖数: 7793 | 30 http://www.fulltiltpokerclaims.com/
GCG, working with the Asset Forfeiture Unit of the United States Attorney's
Office for the Southern District of New York and the Asset Forfeiture and
Money Laundering Section of the United States Department of Justice, has
completed the review of data provided by Full Tilt Poker ("FTP"). It has
been determined that the calculation formula to be used for the Petition for
Remission process will be based on players' final balances with FTP as of
April 15, 2011 (t... 阅读全帖 |
|
Y******u
发帖数: 1090 | 31 wealth aggregation -> Income inequality increase -> unbalance between
production and consumption -> crisis/depression -> chaos/war -> rebuild and
redistribute -> wealth aggregation ... |
|
e****t
发帖数: 17914 | 32 苹果要搞相机么
Google and Apple are once again going head to head in bidding for a major
collection of patents owned by a bankrupt corporation. According to The Wall
Street Journal, two consortiums have formed to bid for the patents owned by
camera giant Kodak, which is currently in bankruptcy.
Apple, Microsoft, and patent-aggregation firm Intellectual Ventures are
teaming up, while Google, Samsung, LG, HTC and RPX Corp are forming the
second alliance.
The people familiar with the discussions cautioned... 阅读全帖 |
|
r*********n
发帖数: 234 | 33 Hi guys,
I just set up a website called PopBuzz.me. It aggregates news from popular
websites and display them based on
how many times the news has been shared on Facebook, twitter and Google buzz
.
Please help us to vote the website on Killerstartups.com. Thank you very
much and wish you a great day!!!
http://www.killerstartups.com/Web20/popbuzz-me-an-aggregator-of-the-latest-news |
|
H**r
发帖数: 10015 | 34
> About us
ABOUT US
Your gateway to World Universities and Colleges
4 International Colleges & Universities is an international higher education
search engine and directory reviewing accredited Universities and Colleges
in the world. 4icu.org includes 10,000 Colleges and Universities, ranked by
web popularity, in 200 countries.
Being a non-paid directory, 4icu.org is free of charge to both visitors and
organisations included. No registration is also required.
Organizations included
The ... 阅读全帖 |
|
|
a**u
发帖数: 8107 | 36 ☆─────────────────────────────────────☆
xztah (funing) 于 (Tue Apr 6 15:41:09 2010, 美东) 提到:
念经带给我的收获和喜悦 - 乐飞翠儿(2009-10-26 16:46:18)转载标签：超度佛法改运
婚姻灵性杂谈命理事业玄学 分类：网友反馈
在这里我还是要先谢谢您们，谢谢卢台长的无私和指导，谢谢工作人员为我们服务！
先说说我在念经前的情况吧：在我过往的人生中好多事都不如意，包括生活、学习、工
作、感情等，我总会想为什么我这么倒晦呢？（我相信很多博友都会有我同样的想法）
，还去看相啦，请人看风水啦，并且我早几年前也在与我契娘的接触中皈依了佛门（我
契娘念佛很多年了），但从来没人教过我应该怎么念经，念什么经有什么功能，又或什
么经不可以随便念等，做了这么多了对我也没什么改变，渐渐的我就心淡了、放弃了念
经，我妈妈也跟我一样不再相信了，我姐姐更是从来没信过。
再说我是如何知道卢台长的吧：这就要从我姐姐先说起了，开始是她上新浪网时无意中
看到卢台长的博客，然后告诉我的，我就问她：（您信吗？）我姐姐说... 阅读全帖 |
|
a**u
发帖数: 8107 | 37 ☆─────────────────────────────────────☆
runsun03 (runsun) 于 (Tue Apr 27 11:04:06 2010, 北京) 提到:
基督教：神创造了世界，有第一因，有主宰（有我）
佛教：没有什么神和万能的力量创造世界，万事万物皆是彼此依存，无始以来就是如此
，无第一因，无主宰（无我）
基督教：信徒因为相信基督而上天堂，永生。
佛教：佛弟子通过自我修行而涅槃，永死。
基督教：信上帝的上天堂，不信的下地狱。
佛教：只要行八正道，就能解脱成阿罗汉，不分宗教和信仰。恶人行恶下地狱。
基督教：上帝是全知全能的。
佛教：解脱者非全知全能，佛陀说，如果有人说他是全知全能，就是诽谤他。佛陀如一
个常人一样，生老病死。最后因得了重病而般涅槃。很多阿罗汉都得过重病，有个女阿
罗汉半夜还被强奸。还有个阿罗汉被牛撞死。
基督教：只要信耶稣，信上帝就能得拯救
佛教：信佛陀没用，需要经过漫长乃至累世的自我修行才能真正解脱。
基督教：向上帝忏悔祈祷就可以免罪。
佛教：向佛陀祈祷没用，佛陀也听不见（已涅槃），通过自我修行，证果才能解脱。而
解脱后如果... 阅读全帖 |
|
m*******s
发帖数: 3142 | 38 Venerable U Silananda的书《The four foundations of mindfulness》里面有两处不
理解，我一字一句敲上来
P149 “When commenting on the sentence,"not to get what one wishes,"this
is also suffering, the commentator said that the desire for what is
unattainable, what you cannot get, is suffering. In the sutta itself, it
is explained that desire for form,etc., is the object of the second
noble truth which is desire of craving. Therefore, desire can be the
object of another desire. The Venerable Mahasi Sayadaw teaches us that
... 阅读全帖 |
|
S**U
发帖数: 7025 | 39 "Bhikkhus, that clinging is neither the same as five aggregates subject to
clinging, nor is the clinging something apart from five aggregates subject
to clinging. But rather, the desire and lust for them, this is the clinging
there."
CDB vol. I, p. 924 |
|
Y**u
发帖数: 5466 | 40 因为道无名，所以称为道，道若有名，就叫那个名字啦。。：）
In the same token, if any of the five aggregates is still there, it's called
aggregate; it's called nirvana just because there the subjugation is
complete. |
|
J******s
发帖数: 7538 | 41 TrueStory,
I did not say that you said 'six realms' is the core of Buddhism. What I was
saying is if you really want to understand or take the meaningful points in
Buddhism theory, focusing on whether there are 'six realms' is not a good
way. Because now you can neither prove this theory is right nor wrong by
your own experiences. We can read the book about others' experiences, but
for me they are like stories, and I won't take them so seriously.
I do not know why it (six realms) is included in... 阅读全帖 |
|
|
k****s
发帖数: 1209 | 43 Verse 1
arya-avalokitesvaro bodhisattvo gambhiram prajnaparamitacaryam caramano
vyavalokayati sma: panca-skandhas tams ca svabhavasunyan pasyati sma.
The noble bodhisattva, Avalokitesvara, being engaged in practicing the deep
transcendental wisdom-discipline, looked down from above upon the five
skandhas (aggregates), and saw that in their svabhava (self-being) they are
devoid of substance.
Verse 2
iha sariputra rupam sunyata sunyataiva rupam, rupan na prithak sunyata
sunyataya na prithag rupam,... 阅读全帖 |
|
k****s
发帖数: 1209 | 44 Verse 1
arya-avalokitesvaro bodhisattvo gambhiram prajnaparamitacaryam caramano
vyavalokayati sma: panca-skandhas tams ca svabhavasunyan pasyati sma.
The noble bodhisattva, Avalokitesvara, being engaged in practicing the deep
transcendental wisdom-discipline, looked down from above upon the five
skandhas (aggregates), and saw that in their svabhava (self-being) they are
devoid of substance.
Verse 2
iha sariputra rupam sunyata sunyataiva rupam, rupan na prithak sunyata
sunyataya na prithag rupam,... 阅读全帖 |
|
s**o
发帖数: 26 | 45 你是说把很多个blog做成planet，那应该是要用一个aggregator
然后这个planet上的blog都需要有full-context rss输出
（也可以没有全文输出的，不过planet站上就会有这个blog
也不是全文输出）
好像除了planet aggregator还有一个java版的，不过需要
google一下了。
这里是planet: http://www.planetplanet.org/
这里是用planet做的gnome planet
http://planet.gnome.org/ |
|
c********d
发帖数: 4 | 46 yes. generally, all of the items in the select list must have a single value
for each group of rows. that is to say,
1. a constant
2. column function, i.e. aggregation funtion. the function will produces a
single value summarizing each group of rows.
3. grouping column (which has the same value in every row of the groups by
definition).
4. an expression involving all of the above (1, 2 and 3)
so in your case, germo is right. you have missed the aggregation function
obviously. |
|
m**********2
发帖数: 2252 | 47 SQL server 2005
运行下面的query:
SELECT p.[Code],
COUNT(*) AS leads,
SUM(CASE WHEN p.[Stage] ='ENR' THEN 1 ELSE 0 END) AS ENR1,
SUM (CASE WHEN (p.[Stage]='ENR' AND p.[ID] IN (
SELECT b.[ID] FROM tbl2 b)) then 1 else 0 end) AS ENR2 FROM tbl1 p
WHERE p.[Code] IN
(xxxx)
GROUP BY p.[Code]
ORDER BY p.[Code]
然后得到一个error message:
Msg 130, Level 15, State 1, Line 1
Cannot perform an aggregate function on an expression containing an
aggregate or a subquery
google了一下这个message,说是：
you cannot use subquery when |
|
v*****r
发帖数: 1119 | 48 不是说非要用 having, LZ 的 concern 是能否避免 subquery, 不管用aggregate 或
analytic function，他提的问题无法避免 subquery, aggregate/analytic function
都必须要用在 subquery 里。
Vis |
|
m*********y
发帖数: 389 | 49 Here are some questions I copied from online.. Obviously LouZhu is a lazy
ass... these questions are everywhere... :-)
SQL Interview questions
Below is a list of questions in this blog post so you can test your
knowledge without saying answers. If you would like to see questions and
answers please scrool down.
Question: What type of joins have you used?
Question: How can you combine two tables/views together? For instance one
table contains 100 rows and the other one contains 200 rows, have exac... 阅读全帖 |
|
