g*l
发帖数: 385 | 1 不是大侠, 也可以帖 code 试试, 别光看帖 呵呵.
desc |
|
p*****s
发帖数: 4393 | 2 看100份opening desc, 把里头比较hot的关键词填到你简历里（当然得是你会的东西）
。 猎头会把你电话打爆的 |
|
c**s
发帖数: 43 | 3
cover letter也很重要的吧。我每次都要花几个小时根据公司的情况和job desc写
cover letter的。尽量压缩在一页。最好是在简历里面挑两三点最相关的强调一下。 |
|
j***y
发帖数: 2074 | 4 搜索了个答案，大家给看看：
CREATE TABLE orders
(Order_ID integer,
Order_Date date,
Customer_SID integer,
Amount double,
Primary Key (Order_ID),
Foreign Key (Customer_SID) references customers(SID));
SELECT Customer_Firstname, Customer_Lastname, orders.Number
FROM customers
INNER JOIN (SELECT Customer_SID, count(*) as Number from orders Group by
Customer_SID order by Number desc limit 5) AS orders
on customers.Customer_ID = orders.Customer_SID ; |
|
a**********2
发帖数: 340 | 5 可以用merge sort(desc)吧
思路更简单：
merge 的时候对于前半部分的元素i和后半部分的元素j
如果input[i] >= input[j] 那么i对应的元素的count就应该增加 high-j+1
这样每次merge的时候都保证后半部分比他小的元素被加进来了
worst case也是O(nlogn） |
|
s******n
发帖数: 44 | 6 不是高手,不过你可以用SQL ANALYTIC FUNCTIONS.
PRICE- LAG(PRICE, 1, 0) OVER (PARTITION BY STOCK ORDER BY DATE DESC) |
|
h**********d
发帖数: 4313 | 7 你问问公司有没有sepcification
给一个我曾经面试的presentation文件desc看看：
Technical - 40 minutes
The next 40 minutes are the real focus of the presentation - the technical
portion. You’ll want to discuss technical details of a recent and/or
significant project or projects. Please focus specifically on your role and
hands-on contribution to the project (rather than team accomplishments). Go
into as much detail as you can with relation to your own leadership,
contribution, and hands-on work. Please remember, it d... 阅读全帖 |
|
r******n
发帖数: 170 | 8 SELECT pr.id, sa.volumn, pr.age from person pr, sales sa where pr.id=sa.id
group by pr.region order by sa.volumn desc , pr.age
region
of |
|
|
d****n
发帖数: 130 | 9 感觉是不大好。还问我想回答C++问题还是multithreading，我说C++吧，再说job desc
ription里也没multithreading的要求。然后他说那就问multithreading。然后一边问问
题，一边吃香蕉。
他们的manager倒是举止得体，聊得也挺愉快。 |
|
P**********c
发帖数: 3417 | 10 这个跟我在Two Sigma的经历类似，一个老中，问我平时写不写Java, 我说不写，主要
写C++, 简历里也没写我会Java. 然后他就说说那你用Java写这个问题吧。。。
desc
问问 |
|
I*******x
发帖数: 20 | 11 select salary from Salary where Employee=A order by TimeStamp desc limit 1; |
|
j********e
发帖数: 1192 | 12 不考虑performance，可以:
select t1.sid, count(*) n from tbl t1,
(select pid from tbl where sid=x) t2
where t1.pid = t2.pid and t1.sid != x group by t1.sid
order by n desc limit 1;
supplier |
|
y***t
发帖数: 644 | 13 SELECT E.EMPID AS EMPID, E.NAME AS NAME, LOCATION, E.SALARY+B.NBONUS AS
TOTAL FROM EMPLOYEES E INNER JOIN BONUS B ON E.EMPID = B.EMPID ORDER DESC BY
TOTAL LIMIT 1 |
|
s********e
发帖数: 15 | 14 你应该申请。 因为公司HR post 出来的东西不一定是HM 想要的。 特别是大公司， 因
为HM 把JOB DESC 给HR 后， 有compensation 的人和compliance 的人要看。 然后他
们就会根据JOB GRADE 来改它。 |
|
t*******e
发帖数: 274 | 15 第一题sql是不是可以这样写：
SEL TOP 1 quid, COUNT(aid) AS ans_count
FROM P_Support_CN_T.survey_log
WHERE eventtype = 'answer'
GROUP BY quid
ORDER BY ans_count DESC;
我在teradata上可以跑通，但不知道语法是不是通用 |
|
t*******e
发帖数: 274 | 16 嗯，是我没看清题目，如果要算rate的话是有点复杂，我改了下，应该有更好的答案：
SEL TOP 1 a.quid, (CAST (a.sum_ans AS NUMERIC(5,3)) / b.total_count) AS ans_
rate FROM
(SEL
quid,
SUM(CASE WHEN eventtype = 'answer' THEN 1 ELSE 0 END ) AS sum_ans
FROM survey_log
GROUP BY quid) a
JOIN
(SEL quid, COUNT(*) AS total_count FROM survey_log
GROUP BY quid) b
ON a.quid = b.quid
ORDER BY ans_rate DESC;
不过这题如果是电话面试中问我，也得想好一会，而且语法上说不定还有错 |
|
d***e
发帖数: 793 | 17 为什么要用self join？
select quid
from survey_log
group by quid
order by sum(case eventtype = 'answer' then 1 else 0 end)/count(*) desc
limit 1 |
|
c**********s
发帖数: 410 | 18 没看明白为什么要用self join阿，如果是我，我可能会这样写, 不知道对不对阿，请
大家指点：
select s1.question_id
from survey_log s1
group by s1.question_id
order by
(select count(*)
from survey_log s2
where s2.question_id=s1.question_id and s2.aid is not null)/(select count(*)
from survey_log s3 where s3.question_id=s1.question_id) desc limit 1;
。。 |
|
|
A*****i
发帖数: 3587 | 20 我就非常好奇这种job desc都是哪个白痴写的
最常见的还有event driven programming skills等
每次看见这些描述我都想笑 |
|
H******7
发帖数: 1728 | 21 我的答案一直得到wrong answer
SELECT Salary FROM Employee ORDER BY Salary DESC LIMIT N, 1
谁给指点一下！？谢谢 |
|
a*****a
发帖数: 46 | 22 select if(s=2147483648, null, s) from (
(select 2147483648 as s)
union all
(select distinct Salary as s from Employee)
) x
order by s Desc limit N, 1
这个可以过，但估计不是很好 |
|
s***y
发帖数: 904 | 23 select name, salary from
(select name, salary, (rank ()over (order by salary desc)) as rank) tabel1
where table1.rank=n |
|
r****n
发帖数: 63 | 24 DECLARE M;
SET M=N-1;
SELECT DISTINCT Salary FROM Employee ORDER BY Salary DESC LIMIT M, 1; |
|
a*****2
发帖数: 96 | 25 CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
RETURN (
# Write your MySQL query statement below.
SELECT IF((SELECT COUNT(DISTINCT(Salary)) FROM Employee) < N, null,
orderedtable.Salary) AS 'NthHighestSalary'
FROM
(SELECT DISTINCT (Salary) AS Salary FROM Employee ORDER BY Salary
DESC LIMIT N) AS orderedtable
ORDER BY orderedtable.Salary ASC LIMIT 1
);
END |
|
w*******2
发帖数: 35 | 26 问题如下：
Write a program to create a customer's bill for a company. The company sells
only five different products: TV, VCR, Remote Controller, CD Player and
Tape Recorder. The unit prices are $400.00, $220, $35.20, $300.00 and $150.
00 respectively. The program must read the quantity of each piece of
equipment purchased from the keyboard. It then, calculates the cost of each
item, the subtotal and the total cost after an 8.25% sales tax. The input
data consists of a set of integers representing th... 阅读全帖 |
|
e*******o
发帖数: 4654 | 27 改offer
改成中性的职位 比如技术助理
job desc 中填加 利用你PhD期间学的东西为公司服务 扯的越多越好
真卡你你没办法 |
|
n*******s
发帖数: 17267 | 28 倒也是，没搞清楚具体问啥，单纯搞名字的话，desc, all_tab_columns都能弄出来，
mysql那种直接show columns也行，让楼主自己去狗吧。 |
|
|
S********C
发帖数: 66 | 30 RT 本来在农村当码农，然后因为不想再农村呆了，申请了一个总部的岗位 JD上写的好
好地java岗位
然后结果虽然是要内部调动 但是电面 onsite也是一样不能少，又面design的又面算法
。
然后当时几个面试官和hiring manager给我留下的映像就是说 我们这里有onboarding
和user 2块。 c艹基本上现在仍在使用的legacy code 是user小组的。然后java是要
onboarding小组的， 同时 我们也要用java重写 那些c艹的很老的legacy code使得他
们 更加scalable。然后我之前在农村分部也是当java的码农 学校也是一直java，所以
应该就是把我放在onboarding小组里（此时仍是和job desc一致的）。
然后好不容易onsite也通过了 又要再来一轮senior director面试， 问了几个问烂
behavior后 就问我你对你要来的岗位清楚吗？ 我说我知道的，就是onboarding小组写
java。 然后director脸一板，说不是的，是user组 你要维护和开发C++legacy code,
这些c... 阅读全帖 |
|
m***i
发帖数: 141 | 31 我找到了老美反对OPT的水军，一模一样的评论在短时间内被发了无数次。请问怎么举
报？谁可以帮忙举报？
去这个链接看Oct 09的评论
http://www.regulations.gov/#!docketBrowser;rpp=50;so=DESC;sb=po
搜“would be a detriment to American tech workers, especially ”你就会发现很
多重复的评论在被换着名字不停的发。这些ID都有
ICEB-2015-0002-7377
ICEB-2015-0002-7151
ICEB-2015-0002-7150
ICEB-2015-0002-7252
ICEB-2015-0002-7470
ICEB-2015-0002-7116
ICEB-2015-0002-7113
ICEB-2015-0002-7131
ICEB-2015-0002-7040
ICEB-2015-0002-7190 |
|
发帖数: 1 | 32 我自己感觉我做对了 但是面我的烙印非说不对 我把我的答案贴在这里
Given two tables
1. Candidate: Id , Name
2. Vote: Id, CandidateId(this is the id being voted)
Give query to give the name of the winning candidate
我的答案 因为也没有指定具体那个SQL 所以我认为把logic回答出了就可以了
select Name, Votes from (
select c.Name as Name, count(v.Id) as Votes
from Candidate c join Vote v on c.Id = v.CandidateId
group by c.Name
order by COUNT(v.Id) desc )
limit 1 |
|
发帖数: 1 | 33 我试着写了一个，用的是 implicit join
select Name from Candidate c,
(select CandidateId from votes order by count(CandidateId) desc limit 1 )
votes
where c.Id = votes.CandidateId.
会不会看起来更加清楚些。 |
|
发帖数: 1 | 34 请问
select CandidateId from votes order by count(CandidateId) desc
count（CandidateId）什么意思？ 难道是产生 每个CandidateId的频率统计？ 我的理
解是 count（CandidateId）产生CandidateId到底有多少个distinct value？ |
|
发帖数: 1 | 35 有个地方需要 clarify 一下，就是 votes 表中一个Id对应多个 CandidateId ，
语法应该是？
select count(id) IDs, CandidateId from votes group by CandidateId order by
IDs desc |
|
r**********d
发帖数: 510 | 36 Please find me a DS job desc that only requires sql. I want to apply. |
|
发帖数: 1 | 37 在职证明好要，但perm要的是经验证明，连新公司perm上的job desc和skill都不知道
，离职的时候怎么要，还的后来要
: ye,离职时就把这些破事一次做完省的以后需要的时候再做，以后HR可能不鸟或
是一拖
: 拖几个月
: 司吗？
|
|
T*******S
发帖数: 103 | 38 刚找工作，看到很多工作上面这样写，不知道什么意思。如果job desc 上面有如此不
懂的东西能问那个公司的hr吗？会不会显得…… |
|
h****n
发帖数: 298 | 39 Title: Operation Assistant (freight forwarding, logistic)
Job Desc:
• Prepare of documentation for export function
• Book, trace, initiate shipments from pick up location to
destination
• Issue pre-alerts or detailed report for customers as requested
• Initial setup of export shipment
• Prepare inland truck BOLs
• Booking & coordination of most cost effective and efficient means
to export goods within customer requirements
• Data ent... 阅读全帖 |
|
|
|
|
w******r
发帖数: 793 | 43 其实就是比较挤的意思。LOL
This is what I interpret after read so many house desc, cozy= small |
|
f**********n
发帖数: 46 | 44 1108 18th Avenue NE , Minneapolis, MN 55418 新房子，卖30万（我觉得贵了些，但
是不知道能否讲下价来。）地下室还没建好，大概800sf。大家有何意见，多谢了。
基本信息：Neighborhood: Windom Park
Total Bed/Bath: 3/3 Garage: 2 Year Built: 2013
Style: (SF) Two Stories
Const Status: Completed New Construction
Foundation Size: 912
AbvGrdFinSqFt: 2,000
BelGrdFinSqFt:
Total Fin SqFt: 2,000
Acres: 0.09
Lot Size: 44x95
Legal Description: LOT 000 BLOCK 001 HARRISON ST SUP E SIDE ADDN TO MPLS E
44 FT OF LOTS 19 AND 20
Com... 阅读全帖 |
|
w********0
发帖数: 377 | 45 谢谢你，我一早就查了空调的warrenty的情况。在厂家网站查到了。这个就应该是大家
说的10年warrenty吧。我一会就联系他们的dealer看看。真是太感谢你了。真后悔修之
前没有上班上问问。哎！当时太着急了，屋里有太热，当时有点不顾一切了。
Warranty Information
Model: CAPF4961D6 Rev: AA
Model Desc.: CASED A-COIL 48K-60K 30"WIDE
Reg Date: 07/01/2009
Install Date: 06/30/2009
* Registered Standard Coverage
Coverage Type
Description
Effective Start
End Date
All Parts 10 YEARS PARTS 06/30/2009 06/30/2019
Unit Exchange 10 YEAR UNIT REPLACEMENT 06/30/2009 06/30/2019
* Extended Warranty Coverage
Covera... 阅读全帖 |
|
|
|
|
|
|
