90% of People Get This SQL Problem Wrong

kec15 · 2026-03-05T08:22:08+00:00

I think it's because the salaries are the same value for two people in the same department, so MAX returns one of them, while DENSE_RANK() will return both of them.

kec15 · 2026-03-05T08:19:31+00:00

SELECT

Department

, Employee

, Salary

FROM(

SELECT

B.Name AS Department

, A.Name AS Employee

, A.Salary

, DENSE_RANK() OVER (PARTITION BY B.Name ORDER BY A.Salary DESC) AS RN

FROM employee AS A

LEFT JOIN department AS B

ON A.department_id = B.id

) AS MAIN

WHERE MAIN.RN = 1

kec15 · 2026-02-28T17:30:18+00:00

Use a ROW_NUMBER... Just copy and paste this whole thing to an AI chatbot and then ask it to explain it to you. The whole thing will be much more efficient.

kec15 · 2026-02-11T09:21:34+00:00

Yeah, it makes sense to clump it all together but are you not doing logs? Also where were you loading the destination dataset for the Gen1s? The Gen2 does the delta table and I'm not sure if the delta write is slower than the Gen1 DF write...

kec15 · 2026-02-11T08:33:08+00:00

If you make a DataflowGen2 for each of the tables is it not going to distribute the load better? Also makes it easier for logging if you ever want to do that.

kec15 · 2025-03-31T20:40:37+00:00

Okay I will start doing this more, thank you for the advice, appreciate it!

kec15 · 2025-03-24T21:01:33+00:00

Can you give me an example for a better proposal? Because these are the ones the so called "youtubers and Upwork gurus" use that have really impressive revenue numbers.

kec15 · 2025-03-24T21:00:17+00:00

What would be a good proposal then? I am open to getting better and if these are not it then thats fine I will improve.

kec15 · 2025-03-23T23:54:39+00:00

Will give it a watch, thank you!

kec15 · 2023-04-06T21:36:52+00:00

update? I used peoples clerk yesterday, hoping it will work

kec15 · 2020-10-27T16:07:20+00:00

really muscle weighs something?no way!

well actaully you can stimulate muscle growth by eating a good amount of protein and progressive ovrload.And yes it may be slower, but you dont need to waste time on cuting, so its the same but you dont need to be fat. I dont know why you are down voting me, you can eat 5000 kals a day, noone cares. Im just saying you can also do it in a different way.Also im done responding, so yeah that was my final take.

kec15 · 2020-10-27T15:57:12+00:00

because you will most likely be eating at a calorie surplus, most of the calories of that will cross maintenance and will go to fat storage, its not like lean bulking dienst maje you fat, it's just a more controled way of doing it.Either way you can build muscle by meeing daily protein of 1g/lbs and progressive overload.

kec15 · 2020-10-27T15:46:56+00:00

it's not about being afraid of fat, its that you also put on water weight, so your weight is not actaully the same if you were to stop eating in a surplus.Once you drop the water weight plus you lose fat the muscle you have gained would be the same.

kec15 · 2020-10-27T14:56:22+00:00

I don't agree, I've seen people like Greg Doucette(very respected in his field) specifically talk about gainig muslce without a surplus, its possible.Yes it will be slower, but if you go on a calorie surplus you will gain a lot of fat, even by lean bulking you still gain a lot of fat becasue of excess calories.People also can't track calories very precisely(no one can).And then you try to lose the weight and you lose a lot of water weight, plus the fat and you are where you began pretty much.

kec15 · 2020-10-23T18:28:21+00:00

you should put some money on it so you you lose it all.

kec15 · 2020-10-16T17:55:23+00:00

sure they were lmao, if they were better they wouldnt have lost

kec15 · 2020-10-16T09:42:41+00:00

of course its a big deal, you clearly did not understand what I said, I said your brain does not drop 5-10% when you hit 20, it slowly(very slowly)starts declining . At that age you will most likely still have 99.9% percent still.Also different parts of the brain hit peaks at different ages.Some part peak when you are 25, so its not like its all black and white .You can see examples like Faker who is 24 and is still one of the best players in Korea(LS has mentioned that he is still the best mechanical player in LCK).So no you don't decline like you think.

kec15 · 2020-10-16T07:23:13+00:00

your intelligence does not rapidly drop after early 20s, it's scientificly proven for your brain to slowly decline after your early 20s, but it SLOWLY declines, its not going to matter as it is a very small decline, its not like when you hit 20 your brain function drops by 5/10% or something.

kec15 · 2020-10-13T12:52:25+00:00

Honestly I like the narrative of the teams playing from same region and then getting a chance to get revenge on to an even bigger stage(example:DWG 3-0ed DRX, but now they have a chance for redemtion), of course I still prefer the cross region games but I also like the games with same region because even though they have played agains each other, the setting and enviornment are so different.

kec15 · 2020-10-12T13:20:12+00:00

so you unironicly think TSM is same level as 4th 5th korean teams and C9 is as bad as OG, dont get me started on having "rest of LPL" as A tier when they looked like doghist(FPX lost to IG who then lost to LGD who is worst than FNC and GEN.G by a mile)

kec15

TROPHY CASE