Monday, November 14, 2011

Learning SQL - Count(DISTINCT COL1)

I've been writing SQL for 20 years now and I learned something new today.

Select Count(DISTINCT COL1) From table1;

I had no idea this even existed let alone that Oracle supports it.

No comments:

Post a Comment