Posted by Martin on 09/05/05 01:04

I have a table in which the records a bunch of fields; for this query,
I'm interested in three of them - let's call them Fld1, Fld2 and Fld3.
For each record in the table, these fields may or may not contain data
(a stock ticker symbol - like MSFT, for example). Different records
may or may not contain the same symbol in the various fields.

For example:
Fld1 Fld2 Fld3
Record1: MSFT | GOOG | null
Record2: INTL | ABC | MSFT

I want to execute a query that will read all of the records in the
table and return a single-column list of all the unique symbols and a
count of the quantity of each one - like so:

MSFT | 2
GOOG | 1
INTL | 1
ABC | 1

I have no idea how to do this.

Help?

• Next in forum: Re: Help with SQL query?
• Prev in forum: Using transaction in MYSQL: what are the chances of needing them?
• Thread view: Help with SQL query?

[Reply to this message]