43 ms·
Not really an algorithm but I like to ask about the difference between inner and outer join. It can start a nice conversation about database design, normalizati
by yread 10y ago
Not really an algorithm but I like to ask about the difference between inner and outer join. It can start a nice conversation about database design, normalization, performance, consistency,... I did get quite a few blank stares or "Yeah I do have SQL Server, MySQL, Oracle and PostgreSQL on my CV but I don't actually do it that much" answers, unfortunately.
- matwood 10y agoA full outer join or left or right? If you want to see how old someone is ask them about the * = syntax :) Sadly many people have little idea there exists a world of SQL beyond 'select * from table where foo = bar'.
- yread 10y ago> A full outer join or left or right? That's what I'm trying to do - get the interviewee to ask more :)
- Retric 10y agoOne of the issues is you can easily go a year without using SQL just some ORM. In a job setting a few quick searches and it all comes back but interviews jump from topic to topic really fast.
- Declanomous 10y agoEspecially when it comes to things like inner and outer joins. I honestly can not remember the last time I needed a full outer join. Our database design doesn't really require it for anything that I can think of.