g**e
发帖数: 6127 | 1 我先来一个吧，如果有人面试碰到了请给我包子。
假设有一堆海量数据，每一条信息的内容如下
e.g.
查询条件大概是这样的:
... 阅读全帖 |
|
r*****l
发帖数: 2859 | 2 I'm not very clear of what you mean.
Seems to me that you use ONE session object. Some of the fields in
it are used to store state1 fields and these same fields, with other
fields are used to store state2 fields.
If you submit state2, information for state1 is overwritten. If you
want to restore state1, you need TWO session objects. |
|
l******n
发帖数: 9344 | 3 OK, Beijing
This is my problem.
Table 1 has Year, STATES, Event. STATES may contain many states and use abv,
event contains many events
Table 2 has Year, STATE1, STATE2,..., STATE7, Event1,...,Event10. But STATE1
is using abv, but STATE2 use code, which has to use table 3 to know the abv
. Each state1(to 7) only contains 1 state or nothing.
Table 3 is Statecode, State.
now I want to know how the relationship between table 1 and table 3.
I want to know in year 2008 and 2007, in each state how man |
|
a*****g
发帖数: 19398 | 4 IL Report cards to change
摘要：学校要统计8年级代数通过率
Diana Rado1s article on the new State of Illinois school report cards (
School Report Cards to Change, October 30), highlights several changes in
this year1s report cards, including the reporting of data about the
percentage of 8th graders who pass Algebra I. This percentage is supposed to
be an indication of how well a middle school is performing.
With the new report card, having more students passing Algebra I in middle
school is now officially a badg... 阅读全帖 |
|
c*****d
发帖数: 6045 | 5 呵呵,欢迎longtian版主光临数据库版
先介绍几个deal给我们吧 ;-)
估计这个就是个人使用
所以规范化,效率也就不用太严格了
tab_A (start_date, end_date, state)
tab_B (start_date, end_date, state1, state2, state3)
select * from tab_A a, tab_B b
where a.start_date < b.start_date
and a.end_date > b.end_date
and a.state in (b.state1, b.state2, b.state3) |
|
p****p
发帖数: 3360 | 6 争取进入决赛争冠军的：
东部
Atlanta1
Chicago2
Toronto3
Washington4
Cleveland5
西部
Golden State1
Portland2
Memphis3
Dallas4
Houston5
L.A. Clippers6
San Antonio7
Oklahoma City10
－－－－－－－－－－－－－－－－
全力摆烂的：
Boston
Philadelphia
New York
L.A. Lakers
Minnesota |
|
d*****r
发帖数: 39446 | 7 【此篇文章是由自动发信系统所张贴】
⊙ 博彩开启于：Wed Oct 14 15:56:07 2015 类别：单选
⊙ 主题：PSU@OSU-14
⊙ 博彩题目描述：
Saturday, October 17, 8:00 PM on ABC
Ohio Stadium, Columbus, Ohio
Penn State
Nittany Lions
(5-1)
@
Ohio State1
Buckeyes
(6-0)
【选项如下】
(1) PSU>=OSU-14
(2) PSU |
|
d*****r
发帖数: 39446 | 8 【此篇文章是由自动发信系统所张贴】
⊙ 博彩开启于：Sun Oct 18 10:18:40 2015 类别：多选
⊙ 主题：PSU@OSU-14
⊙ 博彩题目描述：
Saturday, October 17, 8:00 PM on ABC
Ohio Stadium, Columbus, Ohio
Penn State
Nittany Lions
(5-1)
@
Ohio State1
Buckeyes
(6-0)
【打对勾者正确选项】
(1) PSU>=OSU-14
√(2) PSU |
|
f*****l
发帖数: 80 | 9 看上了的390106242275，写的是new，但不知道是哪里产的？
哪位买过他的东西，可告知一下啊。
谢谢！ |
|
|
t*******w
发帖数: 50 | 11 刚在ebay上下单，还没有付款。价格比市场价低$100。大家给帮忙看看这家店可靠不。
Seller是tri-state1。上面还有三台。
主要用来拍娃。之前想选nikon d5100。后来看评价说操作不方便。这个K-01在DxOMark
上sensor评价还不错，79分。又带个定焦镜头，所以很动心。
补充说明：新手一个。之前买过一个松下GF2。用了快一年觉得成像质量不好，就在
ebay上又卖了。
谢谢。 |
|
|
a***e
发帖数: 27968 | 13 点那个广告，会出来个商家list
这次比较奇葩beachcamera也在上面算大店。另外还有ritzcamera和tri-state1
灰货也还可以
★ 发自iPhone App: ChineseWeb 13 |
|
n********6
发帖数: 1511 | 14 Is it for production? Or just for your research?
If it is just for your research, change the full state name to abv and put
them in a temp table might be a way with clear logic for later process.
abv,
STATE1
abv |
|
B*****g
发帖数: 34098 | 15 好像有点复杂。
state3-7是word，还是code？
你用那个DB？ version？
abv,
STATE1
abv
are |
|
B*****g
发帖数: 34098 | 16 你也搞deal？
我觉得sql应该是
select * from tab_A a, tab_B b
where a.start_date > b.end_date
and a.end_date > b.start_date
and a.state in (b.state1, b.state2, b.state3) |
|
