Sql Help!! - Calgarypuck Forums - The Unofficial Calgary Flames Fan Community

Calgary Flames · 01-13-2006, 10:50 AM

How do I write a sql statement that would add up the population of "Men" and "Women" from the table called "Calgary" in SQL?

Help a brother out!

arsenal · 01-13-2006, 11:15 AM

I think you may want an nvl in that query as well.

Bobblehead · 01-13-2006, 12:01 PM

How is the data stored in the table?

arsenal · 01-13-2006, 01:05 PM

Quote:

Originally Posted by fotze

I dunno, I've never programmed in SQL, I was seeing what access would show me if a viewed a query in SQL.

Depends.. could be close, but Access probably gives you MSSQL, which has a little different syntax that Oracle.

probably something along the lines of:

Code:

select sum(nvl(count(men)) + nvl(count(woman))) from calgary

Calgary Flames · 01-13-2006, 01:31 PM

Gah, you were all too late, and fotze. that didn't work... at all. arsenal is closest it has something to do with Sum, btw this was Oracle9i SQL stuff.

thanks though

Bobblehead · 01-13-2006, 02:00 PM

You needed to tell me what your data looked like (I'm an oracle DBA)

The NVL needs another argument

NVL(field, 'whatever you want it to be if field is null')

Calgary Flames · 01-13-2006, 02:02 PM

I needed to add up the population of Men and Women columns in the table "Calgary" Seperately, How many men there are total and how many women.

arsenal · 01-13-2006, 03:07 PM

Quote:

Originally Posted by Bobblehead

You needed to tell me what your data looked like (I'm an oracle DBA)

The NVL needs another argument

NVL(field, 'whatever you want it to be if field is null')

oops, forgot about that.

But yah, in order to help, need to know how the data is structured in the table.