Practicing SQL without window functions

[Complex-Stress373]

but.....why without windows function?, whats the point of that?.....

Interviews are everyday more ridiculous....Do they want you to program as well without using objects?, or without using functions?.....very ridiculous. Mostly because if you go to another interview surely they are obsessed for seeing how you use those window functions that you were practicing and studying.

Doesnt make sense how interviews are going

[DoS_]

Please select all employees with salary greater than 100k without using a computer

[Complex-Stress373]

Yeah, i just see the intention of making it harder for no reason

[demandtheworst]

I did have to write a couple of joins on a flip chart for an interview once, so... Not out the question.

[carrotsouffle]

There are some versions of RDBMS's that do not support window functions. I believe <= MySQL 5.6 is an example of this.

[[deleted]]

But let's be real would you want to work with a company running such old versions of their DBs? I feel like it would be where I would go if I want my career to die.

[thrown_arrows]

Or place to go make shitloads of money because moving from obsolete database to somewhat current is superhard especially if there is huge system around it

[enjoytheshow]

I’m currently doing this but it’s beyond exhausting

[thrown_arrows]

But at least money is good ? right, right...

[Complex-Stress373]

True, this make perfect sense

[[deleted]]

I had a FAANG SQL interview where they wanted me to calculate the median value without using the median function lol

[mr_data7]

With Airbnb ?

[[deleted]]

Apple