Exists is a useful tool that you should certainly know how to use. Whether or not it's faster than distinct depends on the rest of the query. I've optimized queries where distinct is faster than exists. It's been some time, but I think it boils down to the relative sizes of the tables and how many of the exists queries actually find something (and how often they find more than one something).
Also, some databases (like clickhouse) allow for `any` joins which avoid producing duplicate rows. For example:
select author.*
from author
inner any join book on (
book.author_id = author.id
and book.title like 'Book%'
)
Agreed, I use the cheapest monitor on this page (currently $69 USD) – a little awkward to change the settings, but runs on USB power, monitors CO2 and temperature, and beeps when you exceed a (configurable) threshold so you know to open a window. I keep it next to my desk
Honestly... this made things confusing without improving my reading ability.
a lot of people actually like scrolling. So many people in fact, that they successfully pressured Apple to add scrolling as an alternative to pagination in iBooks.
I'm one of the people who uses that. I'm trying to be polite, but my honest reaction to this interface was, "oh god, this is awful," when I tried to use the mouse to scroll the page.
Also, some databases (like clickhouse) allow for `any` joins which avoid producing duplicate rows. For example: