DISQUS

DISQUS Hello!  The comments on this profile are unclaimed and thus are unverified.

Do they belong to you? Claim these comments.

Anthony Wilson's picture

Unregistered

Feeds

aliases

  • Anthony Wilson

Anthony Wilson

3 years ago

in Keep first, Keep last on Eddie Awad’s Blog

The two example queries will not return the same results in general.


If there are 2 values of n in the table with equal maximum frequencies (i.e. two modes), then the first query will return both top ranked values. The second query will return the maximum of the two top-ranked values.


Also, see:


select stats_mode(n) from t;


... which will return strictly one of the modes, although we can't predict which one.

3 years ago

in Char or Car? on Eddie Awad’s Blog

I think this is a good compromise solution to at least one of these questions.

3 years ago

in Char or Car? on Eddie Awad’s Blog

My experience here in Australia:


SQL - Sometimes S-Q-L and sometimes Sequel. I myself prefer the spelled out version.
Char - ALWAYS "Char". I've never dreamed somebody would pronounce it as "Car".
Blob, Clob - Always pronounced as they are written.
VI: ALWAYS "Vee-eye", I have never heard "Vie", at least not since my first UNIX experience in 1993.


Vie. That's just crazy :-)

Returning? Login