SQL Query

Discussion in 'Databases' started by protocol96, Dec 11, 2008.

0
  1. #1
    I got a table with number, blood group and name. I need the output like

    Blood Group Count
    B+ 36
    A 33
    O- 12


    Can a single sql query do the thing?
     
    protocol96, Dec 11, 2008 IP
  2. live-cms_com

    live-cms_com Notable Member

    Messages:
    3,128
    Likes Received:
    112
    Best Answers:
    0
    Trophy Points:
    205
    Digital Goods:
    1
    #2
    SELECT `Blood`, COUNT(*) FROM `Table` GROUP BY `Blood`
     
    live-cms_com, Dec 11, 2008 IP
    protocol96 likes this.
  3. protocol96

    protocol96 Peon

    Messages:
    413
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #3
    gracias amigo
     
    protocol96, Dec 11, 2008 IP