麦瑞克锐思特麻丝安德汗配牛掖图熬 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>EE - 电子工程

麦瑞克锐思特麻丝安德汗配牛掖图熬

麦瑞克锐思特麻丝安德汗配牛掖图熬# EE - 电子工程

C*t2009-12-24 08:12

1 楼

代人发
Make Philips Grow
Philips Research Asia – Shanghai (PRA-S) has been established in Shanghai
since the year 2000. Our focus is on breakthrough innovation, aimed
generating new business for Philips, and to support existing business.
Working with industrial and academic partners, we speed up innovation and
help create technologies that really matter and get adopted. We call this
Open Innovation. We are an integral part of Philips’ international research
program and have extensive collaborations with the Philips labs across the
world. PRA-S currently has over 80 research scientists working in the fields
of Healthcare, Lifestyle Applications, and Lighting.
As PRA-S continues to grow, we are constantly looking for dynamic, highly
energized people to join and grow with PRA-S.
If you happen to know others with the same kind of talent, enthusiasm and
pride in a job well done, please let us know. Because when you refer a
friend for an immediate -- or future –- opportunity with PRA-S, we’ll all
benefit!
Job List:
Department Career Center Code Grade Job Position Number of
Vacancy
Engineering 80078 50 Senior Industrial Design Engineer 1
Healthcare 70402 50-60 Scientist for Mechanical Engineering 1
Healthcare 75855 40-60 Scientist for Digital Control 2
Healthcare 70120 60 Scientist for MR Clinical 1
Healthcare 75857 40-60 Scientist for CT High Power 1
Healthcare 76941 60 Senior Scientist for Biomedical Engineering
4
Lifestyle 77347 50-60 Scientist For Intelligence Algorithms 1
Lifestyle 80077 70 Senior Manager for Mechanical System Architect
1
Lifestyle 80076 70 Senior Manager for New Application Development
1
Lifestyle 80459 60-70 Scientist for Internet Application 1
Lifestyle 80476 40-60 Scientist For Chemistry 1
Lifestyle 70163 40-60 Scientist For Physiology 1
Lifestyle 75238 40-60 Scientist For Microbiology 1
Lifestyle 80479 60-70 Scientist for Water Treatment 1
Lifestyle 80475 40-60 Scientist For Applied Physics 2
Lighting 79817 60-70 Senior Manager for New Application Development
1
Lighting 80069 60-70 Principle Scientist for Air Treatment and
Hygiene 1
Lighting 76943 50-60 Scientist for Green building 1
Lighting 69871 50-60 Scientist for Power Electronics 1
Lighting 79820 40-60 Scientist for Lighting Application Design 1
Lighting 79815 60 Scientist for Visual Perception 1
Lighting 79823 50-60 Scientist for Modeling and Simulations 2
Lighting 79816 60-70 Scientist for System Architect 2
Lighting 79819 50-60 Scientist for Biomedical Engineering 1
Lighting 79822 50-60 Scientist for Plant Physiology 1
Lighting 79339 40-70 Scientist for Smart City and Intelligent
Lighting 2
And we are still constantly looking for the talents with the below
technology competence (s):
Open Application
Scientist for Chemistry
Scientist for Physics
Scientist for Biology
Scientist for Computer Science
Scientist for Medical Informatics
Scientist for System Architect and Design
Senior Manager for New Application Development
Should you have any queries, please feel free to contact Vickie Wang, Senior
Talent Acquisition Manager for China R&D at V*********[email protected] Or 86-
21-2412 7686.

m*u2009-12-24 08:12

2 楼

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 1/2
3
2 1/2 3 2 1/2 3 3 1/3
2
3 1/3 2 3 1/3 2 4 1/4
3
4 1/4 3 4 1/4 3 5 1/5
2
5 1/5 2 5 1/5 2 6 1/6
3
6 1/6 3 6 1/6 3 null null
null
预期答案应该是： id date
2 1/2
4 1/4
6 1/6

k*g2009-12-24 08:12

3 楼

从最新的 windows 7 里抠出来的，比 vista 里的雅黑改进不少，譬如“桌”字，
vista 的雅黑，中间那个“曰”字里的横道儿重合了，但是在 windows 7 里面已经修
正了，因此如果用来看书，效果会好一些，字体也更顺眼些（原来的雅黑在
cleartype 下总觉得大小不一样），cab 文件，ppc 和 smartphone 的 wm5 和 6 都能
安装：
http://www.megaupload.com/?d=3WUF7YN5
or
http://www.yousendit.com/download/TTZtL0dOWkJlM1N4dnc9PQ

l*e2009-12-24 08:12

4 楼

【以下文字转载自 Quant 讨论区】
发信人: lawbee (lawbee), 信区: Quant
标题: 有人了解中信信托的风投部门吗?
发信站: BBS 未名空间站 (Tue Nov 9 16:25:26 2010, 美东)
现在有个机会,准备年底回去面试.如果有offer,国内这种风险投资公司,收入好吗?

L*r2009-12-24 08:12

5 楼

麦瑞克锐思特麻丝安德汗配牛掖图熬

m*u2009-12-24 08:12

6 楼

I can run the query. But I just don't like the query.

y*32009-12-24 08:12

7 楼

据说中信的工资比较低，跟CICC不是一个级别的。

【在 l****e 的大作中提到】

: 【以下文字转载自 Quant 讨论区】
: 发信人: lawbee (lawbee), 信区: Quant
: 标题: 有人了解中信信托的风投部门吗?
: 发信站: BBS 未名空间站 (Tue Nov 9 16:25:26 2010, 美东)
: 现在有个机会,准备年底回去面试.如果有offer,国内这种风险投资公司,收入好吗?

h*y2009-12-24 08:12

8 楼

了解

m*a2009-12-24 08:12

9 楼

try this (date function may be wrong in your sql system):
Select w2.id, w2.date
from weather w1 join weather w2
on w2.id = w1.id
where w2.temp > w1.temp and w2.date = w1.date +1

【在 m******u 的大作中提到】

: I can run the query. But I just don't like the query.

f*r2009-12-24 08:12

10 楼

你的工作是什么？背景如何？才好回答吧

m*u2009-12-24 08:12

11 楼

你说的对，date作为column head要加中括号。你的query更好一些。我的实在是太难看
了。

m*a2009-12-24 08:12

12 楼

我的SQL没有正式学过，就是工作中有很多的server side 的SQL
所以我不是dba,就是一个用到简单SQL 的吗农
我没有看懂你说的date要加括号是啥意思
这个query在你的系统，我猜是microsoft sql server中可以run不？

【在 m******u 的大作中提到】

: 你说的对，date作为column head要加中括号。你的query更好一些。我的实在是太难看
: 了。

m*u2009-12-24 08:12

13 楼

date在SQL Server里是一种数据类型，所以是保留字，不能用于变量名（这里也即列名
）要用作列名要加个中括号。你的query在sql server中不work。
发信人: mdrosophila (ranger), 信区: Database
标题: Re: 这个query对么？
发信站: BBS 未名空间站 (Tue Jun 23 22:15:03 2015, 美东)
我的SQL没有正式学过，就是工作中有很多的server side 的SQL
所以我不是dba,就是一个用到简单SQL 的吗农
我没有看懂你说的date要加括号是啥意思
这个query在你的系统，我猜是microsoft sql server中可以run不？

m*a2009-12-24 08:12

14 楼

我不知道为啥不行，你可以用下面三种方法escape reserved word in sql.
w1.date已经是escape了
你能说说，咋样写是对的？
date is a reserved keyword and hence cannot be used like
SELECT date from some table
there can be multiple solutions for the problem
The date column needs to be enclosed within the brackets like
SELECT [date] FROM tableName
Enclose the reserved keyword in backticks
SELECT 'date' from tableName
Use alias
SELECT tableName.date from tableName

【在 m******u 的大作中提到】

: date在SQL Server里是一种数据类型，所以是保留字，不能用于变量名（这里也即列名
: ）要用作列名要加个中括号。你的query在sql server中不work。
: 发信人: mdrosophila (ranger), 信区: Database
: 标题: Re: 这个query对么？
: 发信站: BBS 未名空间站 (Tue Jun 23 22:15:03 2015, 美东)
: 我的SQL没有正式学过，就是工作中有很多的server side 的SQL
: 所以我不是dba,就是一个用到简单SQL 的吗农
: 我没有看懂你说的date要加括号是啥意思
: 这个query在你的系统，我猜是microsoft sql server中可以run不？

m*u2009-12-24 08:12

15 楼

已经做了相应改动：将date加中括号，还把最后一行换成了id相减（date类型不能相减
），但仍不能run。我的那个query能run，并能给出正确结果。

m*a2009-12-24 08:12

16 楼

我看了你的数据，我发现错在哪个地方，原来我以为id是一个area code
比如chicago, new york, LA啥的，所以要找到area code 一样的
你这个表只有一个 area, id只不过是serial number。
但是你不知道id+1是id的后一天，这个假设不一定对，也不需要要left join
用下面的join就行了
Select w2.id, w2.date
from weather w1 join weather w2
where w2.temp > w1.temp and w2.date = w1.date +1

【在 m******u 的大作中提到】

: 已经做了相应改动：将date加中括号，还把最后一行换成了id相减（date类型不能相减
: ），但仍不能run。我的那个query能run，并能给出正确结果。

m*u2009-12-24 08:12

17 楼

Finally I got this query. It works and is not ugly.
;with wCTE (ysd_id,ysd_temp,td_id, td_temp)
as(
select w1.id, w1.temp, w2.id, w2.temp
from weather w1
full join weather w2
on w1.id = w2.id -1
)
select weather.date
from weather
inner join wCTE
on wCTE.td_id = weather.id
where wCTE.td_temp > wCTE.ysd_tem

m*u2009-12-24 08:12

18 楼

其实是一样的。改改，就不是那么难看了。
select w2.[date] as [day with temperature higher than yesterday]
from weather w1
full join weather w2
on w1.id = w2.id - 1
where w2.temp > w1.temp

n*l2009-12-24 08:12

19 楼

using lag() over() to access data from previous row:
WITH LagDate as (
SELECT ID, [date], temp,
LAG (temp, 1, 0) over (order by [Date] ASC) as LagTemp
FROM Weather
)
SELECT id, [date] AS [Dates with temp higher than previous day], temp
FROM LagDate
WHERE temp > LagTemp

m*u2009-12-24 08:12

20 楼

thanks. I like your query.
发信人: ntycl (你太有才了), 信区: Database
标题: Re: 这个query对么？
发信站: BBS 未名空间站 (Mon Jul 6 23:43:31 2015, 美东)
using lag() over() to access data from previous row:
WITH LagDate as (
SELECT ID, [date], temp,
LAG (temp, 1, 0) over (order by [Date] ASC) as LagTemp
FROM Weather
)
SELECT id, [date] AS [Dates with temp higher than previous day], temp
FROM LagDate
WHERE temp > LagTemp