UNIX for Dummies Questions & Answers

Hey all,

I'm trying to locate a good sql forum - similar in nature to this, where I can can get some quick responses to questions I have.

I've tried a few but they are either no longer running - or have one visitor every month.... just wanting to see if anyone uses a forum that is of the same calibre as this one....

Or (not particularly appropriate for this forum) if there is a SQL guru in here that can answer a distinct counting question for me....

here's one i've used, of course it's not as good as this forum!

http://www.tek-tips.com/gthreadminde...ev3/32/pid/220

Alrighty then....I have a table that contains a number of columns.

I want to count the number of instances of each distinct entry in one column.

i.e.

Table has a request_status column - which can have one of 5 states.... approved, rejected, processed ....

I want to count the number of approved and the number of rejected etc. I don't want to do this manually as with 5 it's okay - but I want the syntax for other queries where there are hundreds of states .....

Ooops....checked the reply and all it showed was "here'"

I thought you were saying bring it on..... I already had a look at that forum you have linked...your right it's not that flash.....I'll post but was hoping for a better one......

anyone?

is this what you want;

select count(*),request_status
from table_name
group by request_status

let me know.

- Ed

Yes - Yes -Yes. You can't imagine how long I've looked for that - and it's so simple...easy when you know how I guess....

I don't know what flavor of SQL that you are using, but the SQL Server listserv is quite active and generally has a pretty good response base.

They are located at http://www.sunbelt-software.com/sql_list_charter.htm.