louis's Blog

louis's Avatar Image
Software developer #Go #CommonLisp #JS #SQL. #LispWorks user. Soft spots for #Emacs #SmallWeb. Recently becoming #OpenBSD enthusiast.

Author of the Tuner app for Linux.

Other hobbies: #Running #FireFighter #StarTrek
← All posts

SQL pro tip of the day:

sub-optimal:

SELECT count(*) 
FROM mytable
WHERE mycolum IS NOT NULL;

optimal:

SELECT count(mycolumn) 
FROM mytable;

#sql #postgresql #mysql #sqlite

To like or reply, open original post on Emacs.ch