the following works fine
select sum(QTY * PRICE) as TotalVal, supplierid
from BIDS
where awardID in(2,3)
group by supplierid
order by TotalVal
But I need all the fields from this table ('BIDS') and ordered by 'TotalVal'.
I hope this explains it better than previous post.
Please, at least...
I need something similar to following
select * from table
where columX in (dat1,data2,...)
order by (sum (colum1 * colum2) group by colum3)
Is this possible? and what would be its syntax?
Basically how can I order the query result based on the sum of a column and this sum should be grouped by...
Thanks for the help. I've some more questions though...
So what's "FastCGI"? IS it another way to make the CGI working on APache? If yes, then can someone tell me how?
Thanks
Amar
I have been trying to look for documentation for getting the CGI working on Apache on a Win2K machine. The error I get in the error.log is
[Wed Mar 13 14:39:46 2002] [error] [client 127.0.0.1] couldn't spawn child process: d:/program files/apache group/apache/cgi-bin/first.pl
I read the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.