What is the query to get the number of “names” from a table that is occuring more than 10 times.

June 12th, 2008 | by Shubhabrata |

SELECT name FROM table_name WHERE COUNT(name) > 10

  1. 8 Responses to “What is the query to get the number of “names” from a table that is occuring more than 10 times.”

  2. By parthiban on Sep 17, 2008 | Reply

    Hi
    “SELECT name FROM table_name WHERE COUNT(name) > 10″ this query is not working bz the group functions are used only having clause not for where clause

    so the correct query is

    “SELECT name FROM table_name having COUNT(name) > 10″

  3. By Sumesh on Sep 30, 2008 | Reply

    Correct Query is :

    “SELECT name FROM table_name having COUNT(name) > 10″

  4. By Sumesh on Oct 14, 2008 | Reply

    http://www.phpnew.co.cc/

  5. By Santhosh on Oct 18, 2008 | Reply

    The above queries will not give the required output so try the below query

    select name from postfuel group by cabname having count(cabname) > 10;

  6. By Santhosh fernando on Oct 18, 2008 | Reply

    The above queries will not give the required output so try the below query

    select name from postfuel group by cabname having count(cabname) > 10;

  7. By trivendra on Nov 27, 2008 | Reply

    SELECT name FROM table_name group by name having COUNT(name) > 10

  8. By Jolly Martin on Jan 6, 2009 | Reply

    thanks for the query.

  9. By hemant on Mar 1, 2009 | Reply

    SELECT * FROM tablename Group By name having COUNT(name) > 10

Post a Comment