Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
slc
searching Neon…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
9 ms
·
1.
▲
by
slc
12y ago
"folks" aren't thinking straight ? This sort of attitude is a huge part of the problem. This is why people don't seek mental help - dehumanization.
2.
▲
by
slc
12y ago
The army officials who deny mental health care to soldiers who later completely unpredictably off themselves at a rate higher than combat casualties must have read some of the same literature.
3.
▲
by
slc
12y ago
This is stupid. And I can't believe it doesn't sound stupid to those who are the most likely to attempt suicide seriously. Why doesn't anyone talk about "misery prevention" ?
4.
▲
by
slc
13y ago
You forgot to compare the treatment of the russian speaking people in the baltic states to the treatment of jews in the nazi germany. Both were treated poorly.
5.
▲
by
slc
13y ago
No, I haven't. I live in Latvia. I'm sure that the older generation of Estonians don't like the russians, because they blame them for the ~50 years of life under a communist dicatorship, the relatives lost in the siberian dea
6.
▲
by
slc
13y ago
If you're 15, then you have already received free government funded latvian language courses for 9 years in school. It's part of the curriculum. You'd have to be especially lazy to not be able to pass the citizenship exams.
7.
▲
by
slc
13y ago
Can't speak about Estonia but in case of Latvia the idea of russian speaking people emigrating because of hostility is just ridiculous.
8.
▲
by
slc
13y ago
There are already local "franchises" of the large companies like Tietonator and Accenture. The computer science department of the Latvian University, which provides free government funded education in computer science is basically
9.
▲
by
slc
13y ago
Mixing in the non-citizens in a discussion about demographics seems wrong. Most of the non-citizens are people around retirement age - factory workers who were sent in the country from other soviet countries, military families and so on. Th
10.
▲
by
slc
13y ago
In your example, for each row of the result set * "em.departmentId" will contain one of the distinct values from the "departmentId" column * "salary" will contain the maximum value of the "salary" column of the table rows whose "departmentI
11.
▲
by
slc
13y ago
Probably not the best idea to group on the Departments.Name instead of Departments.DepartmentId ..
12.
▲
by
slc
13y ago
The second question is actually trickier than one might think. The obvious answer - something like select Name, MAX(Salary) from Employees group by DepartmentId is wrong.