借宝地问个面试中的sql的问题。 - Statistics版 - 未名存档

本页内容为未名空间相应帖子的节选和存档，一周内的贴子最多显示50字，超过一周显示500字访问原贴

Statistics版 - 借宝地问个面试中的sql的问题。

相关主题
● request help with oledb connection to Micrrosoft SQL server	● 借宝地问个powerpoint 的问题。
● 问个SAS的问题	● 请教 macro variable 和 PROC SQL的问题
● 问个SAS的问题	● SQL combine two tables into one table and add a new column (转载)
● 统计外行问个组合的简单问题	● compare two large tables SQL (转载)
● 菜鸟问个sas得问题，关于分数组	● sort two same tables SQL but different results (转载)
● 求SQL高手解一题	● SQL find distinct values in large table (转载)
● 完全不懂SAS，急请教一个问题	● keep group of values of SQL procedure in one table (转载)
● MySQL求助	● SAS dataset to sql server

相关话题的讨论汇总
话题: sql话题: student话题: am话题: many话题: 借宝地

进入Statistics版参与讨论

1

(共1页)

s****e 发帖数: 1180	1 借宝地问个面试中的sql的问题。 We have two tables, students (student ID, student name, student age, student zip) and courses (course name, course time) . The information in the parentheses are the schema. We want to get how many students enroll all the classes starting at 11:00 AM? the interviewer mentioned something like many to many join. the interviewer mentioned something like "dimensionalize" in SQL. I am wondering who knows any SQL book on this, and can introduce it me? Thank you so much for your consideration!
D******n 发帖数: 2836	2 这个两个tables咋join？ student AM? 【在 s****e 的大作中提到】 : 借宝地问个面试中的sql的问题。 : We have two tables, students (student ID, student name, student age, student : zip) and courses (course name, course time) . : The information in the parentheses are the schema. : We want to get how many students enroll all the classes starting at 11:00 AM? : the interviewer mentioned something like many to many join. : the interviewer mentioned something like "dimensionalize" in SQL. I am : wondering who knows any SQL book on this, and can introduce it me? : Thank you so much for your consideration!
s****e 发帖数: 1180	3 对我也这么想。应该要加column的。你觉得难吗？【在 D******n 的大作中提到】 : 这个两个tables咋join？ : : student : AM?
a****g 发帖数: 8131	4 google sas sql joining or there are detailed description in the SAS advanced prep there should be a Key student ID in the courses table, which confused dashagen, I guess. student AM? 【在 s****e 的大作中提到】 : 借宝地问个面试中的sql的问题。 : We have two tables, students (student ID, student name, student age, student : zip) and courses (course name, course time) . : The information in the parentheses are the schema. : We want to get how many students enroll all the classes starting at 11:00 AM? : the interviewer mentioned something like many to many join. : the interviewer mentioned something like "dimensionalize" in SQL. I am : wondering who knows any SQL book on this, and can introduce it me? : Thank you so much for your consideration!
s****e 发帖数: 1180	5 答案在这里。 http://www.mitbbs.com/article_t0/Database/31183043.html 【在 a****g 的大作中提到】 : google sas sql joining : or there are detailed description in the SAS advanced prep : there should be a Key student ID in the courses table, which confused : dashagen, I guess. : : student : AM?

1

(共1页)

进入Statistics版参与讨论

相关主题
● SAS dataset to sql server	● 菜鸟问个sas得问题，关于分数组
● 请教SAS SQL	● 求SQL高手解一题
● 除了data analyst 我还能找那些工作？	● 完全不懂SAS，急请教一个问题
● 要去interview了，求教面试SAS projects问题	● MySQL求助
● request help with oledb connection to Micrrosoft SQL server	● 借宝地问个powerpoint 的问题。
● 问个SAS的问题	● 请教 macro variable 和 PROC SQL的问题
● 问个SAS的问题	● SQL combine two tables into one table and add a new column (转载)
● 统计外行问个组合的简单问题	● compare two large tables SQL (转载)

相关话题的讨论汇总
话题: sql话题: student话题: am话题: many话题: 借宝地

未名新帖统计// 7月16日

#	版面	帖数(主题数)
-	全站	4871 (796)
1	Military	3777 (569)
2	Stock	341 (51)
3	Joke	117 (17)
4	History	116 (3)
5	Automobile	100 (9)
6	USANews	55 (9)
7	Midlife	45 (1)
8	Headline	41 (41)
9	Dreamer	33 (13)
10	FleaMarket	32 (20)
11	Living	30 (7)

* 这里只显示发帖超过25的版面，努力灌水吧:-)