I guess this is a pretty basic question, but I was wondering how to list the "top ten" of a column (or "top 100" etc) according to the values in the column.
So for example if I have a customerid column with:
cstokes91, I've seen it all too, I'm still new to SQL (as you can tell) but I was thrown in rather at the deep end with a DB I inherited, and there are many columns that should have been of data types they aren't, including int's that were varchars. :)
I feel your pain man... I graduated from college Spring 2012 with a degree in Management Info Systems and once you actually start getting into this stuff it is a whole different world.
My specific job is especially challenging because I do data transfers from clients data to our system so not only do I have to fully know how our system works but I am constantly learning other people's system to get their data over. I hear it gets easier but I haven't seen it yet ;)
Top Ten; according to value?
Posted - 01/22/2013 : 14:17:54
