z*k
2 楼
sorry i cannot type chinese at work.
I have a collection of records, ordered by date, the record has two other
attributes, say attr and prev, here's a simple example:
date, attr, prev
I have a collection of records, ordered by date, the record has two other
attributes, say attr and prev, here's a simple example:
date, attr, prev
a*r
3 楼
人民币在这两年对非美货币几乎是全面贬值
未来的路在何方呢？
升值->投机资金外逃；世界工厂成本升高？
贬值->通货膨胀高企，民不聊生？
未来的路在何方呢？
升值->投机资金外逃；世界工厂成本升高？
贬值->通货膨胀高企，民不聊生？
f*r
4 楼
如果绿卡名额是CURRENT,不用排期,那么申请人有好处多交$1000去申请加速I 140呢?
另外我先生是欧洲人,申请绿卡是否我的是跟他的走即我们同时拿到绿卡,或是我得慢些拿到?
多谢大侠们的指教,在此叩谢!
另外我先生是欧洲人,申请绿卡是否我的是跟他的走即我们同时拿到绿卡,或是我得慢些拿到?
多谢大侠们的指教,在此叩谢!
i*a
5 楼
basic idea is to use row_number and self joining tables. if you use CTE,
here is an example
with cte as
(
select ROW_NUMBER() over (order by tb1.colDate) as rn1, *
from tableTest2 tb1
)
select *
from cte
inner join (select ROW_NUMBER() over (order by colDate) as rn2, * from
tableTest2) tb2
on cte.rn1 = tb2.rn2 - 1 and cte.attr <> tb2.prev
if you don't want to use CTE or not on SQL server 2005 or later, then put
result from the 1st query into a temp table
here is an example
with cte as
(
select ROW_NUMBER() over (order by tb1.colDate) as rn1, *
from tableTest2 tb1
)
select *
from cte
inner join (select ROW_NUMBER() over (order by colDate) as rn2, * from
tableTest2) tb2
on cte.rn1 = tb2.rn2 - 1 and cte.attr <> tb2.prev
if you don't want to use CTE or not on SQL server 2005 or later, then put
result from the 1st query into a temp table
c*n
6 楼
任何政策都是有两面性的
【在 a*****r 的大作中提到】
: 人民币在这两年对非美货币几乎是全面贬值
: 未来的路在何方呢？
: 升值->投机资金外逃；世界工厂成本升高？
: 贬值->通货膨胀高企，民不聊生？
【在 a*****r 的大作中提到】
: 人民币在这两年对非美货币几乎是全面贬值
: 未来的路在何方呢？
: 升值->投机资金外逃；世界工厂成本升高？
: 贬值->通货膨胀高企，民不聊生？
a*r
7 楼
当然有两面 但方向是哪里呢
【在 c***n 的大作中提到】
: 任何政策都是有两面性的
【在 c***n 的大作中提到】
: 任何政策都是有两面性的
f*0
8 楼
"当然有两面 但方向是哪里呢"
without having better data, it is hard to tell.
pegging to USD (thus devaluaing RMB vs. other currencies) will clearly help
export, but will suppress growing domestic consumption which is going to be
critical to China's sustained growth going forward.
what the leadership took is a compromise: gradually loosening the usd peg so
that rmb strengthens against usd modestly while continue to devalue vs.
european currencies. This will help us export to the US, yet increase
domestic weal
without having better data, it is hard to tell.
pegging to USD (thus devaluaing RMB vs. other currencies) will clearly help
export, but will suppress growing domestic consumption which is going to be
critical to China's sustained growth going forward.
what the leadership took is a compromise: gradually loosening the usd peg so
that rmb strengthens against usd modestly while continue to devalue vs.
european currencies. This will help us export to the US, yet increase
domestic weal
相关阅读
Re: 来篇雄文：国内大学海龟 烂坑校 Black listBeijing's Stimulus Plan May Exacerbate China's Overcapacity (转载)求paper[请教]大家是怎么选择Ph.D.的老板的？request a paperMSU RA vs. BU unfunded请教ph.d.offer选择:UCLA unfunded or Cornell funded请教高手，哪里可以查到美国1925-2008的property tax, housing price and GDP data???如果A教授的能力比 B教授强，中国学者2008年在SSCI商学期刊上发表的论文统计BA econ 毕业出来好找工作吗？工资怎么样请教Nelson Siegel模型的参数确定很困扰,麻烦谁给指个明路吧...请教做corporate finance实证分析的数据，有没有比较有名而又免费的数据库How do you select literature?我这样的背景适合申请什么方向的PHDGranger passed away白重恩等北清教授们的漫漫上访路Questions related to Economics现在做Macro的大牛有哪些？