Thursday, April 7, 2011

Selecting unique entries from a column

I have this table ID | Category | Subcategory |

           1  |      Books       |    Comic         |
           2  |      Books       |   Fiction        |
           3  |      Cars        |     New          |
           4  |      Books       |   Non- fiction   |
           4  |      Cars        |    Second hand   |

and I want to select only unique entries from the column 'Category'. That is, I want 'Books' and 'Cars' to be selected only once. How can I write a query ?? Help please.

From stackoverflow
  • You mean distinct ?

    SELECT Distinct Category
    FROM Table
    
  • Or group by

    SELECT Category
    FROM Table
    GROUP BY Category
    

    Group by enables you to retrieve various aggregates based on your query (such as number of items in category etc...)

0 comments:

Post a Comment

Note: Only a member of this blog may post a comment.