Subject | SubSelect Question |
---|---|
Author | Tom Frey |
Post date | 2003-11-10T22:57:42Z |
Hi,
maybe someone can help me with this:
I have a table with a column that holds negative and positive volume
numbers.
e.g:
100
-250
300
50
you get the idea ;)
Is there a way to select in one SELECT statement an AVG for all
negative volumes and all positive volumes?
maybe someone can help me with this:
I have a table with a column that holds negative and positive volume
numbers.
e.g:
100
-250
300
50
you get the idea ;)
Is there a way to select in one SELECT statement an AVG for all
negative volumes and all positive volumes?