Subject | SQL query help |
---|---|
Author | t_bhoy |
Post date | 2006-12-19T08:58:48Z |
Hi,
I'm wondering if anyone can help.
I have a table column that stores the characters 'Y' or 'N'.
I am trying to write a query that returns the number of 'Y's I have in
relation to the total number of 'Y' and 'N' occurences.
So if the column had Y,Y,Y,Y,N it would return 80 (%) or even
something like 4,5 so that I can have the total number of 'Y's and the
total number of rows.
Any ideas?
Thanks
I'm wondering if anyone can help.
I have a table column that stores the characters 'Y' or 'N'.
I am trying to write a query that returns the number of 'Y's I have in
relation to the total number of 'Y' and 'N' occurences.
So if the column had Y,Y,Y,Y,N it would return 80 (%) or even
something like 4,5 so that I can have the total number of 'Y's and the
total number of rows.
Any ideas?
Thanks