Not signed in (Sign In)

Vanilla 1.1.4 is a product of Lussumo. More Information: Documentation, Community Support.


Archive: MySQL query of count()

Bottom of Page

1 to 1 of 1

  1.  
    • CommentAuthorjustnajm
    • CommentTimeJul 12th 2007
     
    Can I make a single query, in which I can get the total number of records plus the the columns of each record, this is seems to be quite tricky but here what I want to achieve.


    [Job table]

    SELECT COUNT(*), j_id, j_title FROM job;

    #Now this query ask me to put group by, then as I am using count()

    SELECT COUNT(*), j_id, j_title FROM job GROUP BY j_id;

    #This query is throwing an error



    Some one has suggested that this query can be achieved only by executing two, one for count and one for data from columns.

    What you can suggest ?, I think there can be a different way or in a single query this task can be done. But How ???

1 to 1 of 1

  1.