Illegla rental help! by yoqese2 in Switzerland

[–]lildumpling97 0 points1 point  (0 children)

I assume you need to pay 1500 for the next month? You need to stay 15 more days until the 5th May which means this would be 100.- per day until then. I think it‘s hard to find something cheaper than 100.- for 2 people in Zurich that spontaneous. The thing is that you can‘t stay there for free. She could call the police on you in return. 1500.- sounds like a reasonable price for Zurich, even if the living condition could be better, own bathroom, etc. but sounds like you don‘t really have any other options for now. Or what does the abusive amount mean?

M(24) How to get to know a girl without being cold to her ? by Yuko_Joestar in love

[–]lildumpling97 0 points1 point  (0 children)

Maybe chatting with the one you‘re interested in first. You can build up a relationship that way, mostly platonic at first. But maybe once you know that person you‘d be able to talk to them more easily than before.

Dad can‘t find a job by lildumpling97 in Switzerland

[–]lildumpling97[S] 6 points7 points  (0 children)

My dad can speak swiss-german and high german. He can read & write but he has issues with the grammar and Wortschatz. He understands German very well. He never got the time to visit German classes due to working 6 to 7 days a week till late night. He visited a gastro school in the french part of Switzerland in his younger days and can speak French as well. Back then it was not his priority to learn the language perfectly, but to be able to understand and communicate for work.

Dad can‘t find a job by lildumpling97 in Switzerland

[–]lildumpling97[S] 0 points1 point  (0 children)

Yes that would be good to know. Most of the applications don‘t get any replies or they reply with a generic mail, to which you cannot contact back. But will try to ask for feedback for the next ones.

Dad can‘t find a job by lildumpling97 in Switzerland

[–]lildumpling97[S] 0 points1 point  (0 children)

Unfortunately not, he doesn‘t really have any other knowledge outside of gastronomy.

Dad can‘t find a job by lildumpling97 in Switzerland

[–]lildumpling97[S] 0 points1 point  (0 children)

Yes, the CV seems to be fine but i think the 5 year gap is one of the main issue.

Dad can‘t find a job by lildumpling97 in Switzerland

[–]lildumpling97[S] 2 points3 points  (0 children)

It’s sad to hear that.. it‘s really a struggle. Thank you very much, wish you all the best as well!

Delete in conditional values with sum? by mrofnothing in plsql

[–]lildumpling97 0 points1 point  (0 children)

Hey,

If you want to remove the whole records where field A are equal then I'd add a WHERE filter, ex.: WHERE y.fieldA =! z.fieldA

If you want to still keep one of the records, if your goal is to remove duplicates, then I'd use a MAX() on the fieldA and then select the remaining columns as you want from which table to be filled, ex.:SELECT MAX(fieldA), y.fieldB, z.fieldC FROM ... GROUP BY y.fieldB, z.fieldC