Professional Web Applications Themes

selecting the single most common value from a certain column? - MySQL

Hi is there a way of selecting the single most common value from a certain column in a mysql table? Thanks a lot, Ciarán...

Sponsored Links
  1. #1

    Default selecting the single most common value from a certain column?

    Hi is there a way of selecting the single most common value from a
    certain column in a mysql table?

    Thanks a lot,
    Ciarán

    Sponsored Links
    Ciaran Guest

  2. #2

    Default Re: selecting the single most common value from a certain column?

    On 13 Mar 2007 10:36:00 -0700, Ciaran wrote: 

    Almost:

    SELECT my_column, count(my_column) FROM my_table GROUP BY my_column
    ORDER BY 2 DESC LIMIT 1;

    --
    "Friendship is born at that moment when one person says to another, 'What!
    You too? I thought I was the only one!'"
    --C.S. Lewis
    Peter Guest

  3. #3

    Default Re: selecting the single most common value from a certain column?

    Ciaran wrote: 

    SELECT column_name, count(*) as quantity
    FROM table_name
    GROUP BY column_name
    ORDER BY quantity DESC
    LIMIT 1


    Paul Guest

  4. #4

    Default Re: selecting the single most common value from a certain column?

    Wow! I'm not sure what it means but it works great! Thanks a lot!

    Ciaran Guest

Similar Threads

  1. searching for single entry in column
    By mcardeiro@yahoo.com in forum MySQL
    Replies: 3
    Last Post: May 30th, 08:52 PM
  2. Selecting Records based on DB column with list
    By craigkaminsky in forum Coldfusion Database Access
    Replies: 1
    Last Post: May 4th, 07:41 PM
  3. Share common code when developing single Control assemblies?
    By S.Sigal in forum ASP.NET Building Controls
    Replies: 1
    Last Post: August 24th, 11:09 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139