Posted by ian.l.guthrie on 08/16/06 19:04

I have a table consisting of two fields, OStype and OSversion, with
entries like:

OStype OSversion
solaris 2.5
solaris 2.6
redhat 6.2
redhat 6.2
solaris 8
redhat AS4
solaris 10
solaris 10
redhat AS2.1
redhat AS3
redhat AS4

I want to create a select statement that returns for each OS type, the
total number of entries and for each version the total number of
entries.

In the example the result would be:

OStype OStype Count OSversion OSversion Count
solaris 5
2.5 1
2.6 1
8 1
10 2
redhat 6
6.2 2
AS2.1 1
AS3 1
AS4 2


Thanks in advance for your help.

Ian

• Next in forum: Re: copy database via tapefile no SQL 2005
• Prev in forum: Re: suggestions for books
• Thread view: SQL select statement needed

[Reply to this message]