@sqldaily.bsky.social on Bluesky

JavaScript RequiredThis is a heavily interactive web application, and JavaScript is required. Simple HTML interfaces are possible, but that is not what this is. Learn more about Bluesky at bsky.social and atproto.com.

Post

SQLDaily

sqldaily.bsky.social

did:plc:blmnab373idbogizdn742doc

Checking if rows match some criteria? Instead of SELECT COUNT(*) FROM ... Use EXISTS ( SELECT * FROM ... COUNT gets all the rows; EXISTS can stop when it finds a match As @lukaseder.bsky.social says Thou shalt not use COUNT(*) when EXISTS sufficeth thy need https://buff.ly/3EEKMLp

2024-12-10T12:00:04.360Z