Dependent Origination

sql count, sort and group

Posted on: October 26, 2011

My sql knowledge has stayed roughly the same over the years — mostly select’s 🙂 I have resolved to know more about SQL, like at least can work out those interview questions that ask you to find duplicates from a db table 🙂

Here is one example (easy) I have worked out today.

mysql> select column_name, count(*) as c from table_name group by column_name order by c DESC;

This can group all the possible values of a column and count how many rows with each of those values and show the counts in descending order.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

October 2011
M T W T F S S
« Sep   Nov »
 12
3456789
10111213141516
17181920212223
24252627282930
31  

Twitter

  • is reflecting on the past three years and reading the article on divided self aptly showing up at the top of my tweeter feed. 1 week ago
  • is having a nice feeling of connecting dots all over the place. they are now illuminating the same point. 2 months ago
  • Style Transfer is fun! TensorFlow rocks! #WTM17 https://t.co/zYP0IFIDfp 3 months ago
  • couldn't get over the jetlag, sleeping during the day from seven to four, for days. 5 months ago
  • is emptying trash and happily discovering the available disk space now ranks at 100G+. 6 months ago

Flickr Photos

IMG_3517

IMG_3515

IMG_3505

IMG_3497

IMG_3261

IMG_3260

IMG_3255

IMG_2736

IMG_2733

IMG_2629

More Photos
%d bloggers like this: