Another quick work related post of something from yester-year. A slightly edited version of some SQL I wrote one day when I was extremely annoyed about a particular user.

The original contained more in the where clause that identified the person in question, obviously removed for publishing purposes.

=======================================

SELECT *
FROM all_users
WHERE iq > ( SELECT AVG(iq)
                      FROM  uk_flora
                      WHERE genus = ‘Narcissus’ );

0 row(s) returned

=======================================

Bozz, ©Copyright ‘03

Although they say plagarism is the sincerest form of flattery, please don’t get this printed onto a t-shirt before I have! Or at least put a credit to me on the bottom…

Advertisements