×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Hello.
My sql displays as below
select pval,pquant,pgross from USA/ATSFILE
where pcnty='USA'
pval pquant pgross
1 100 100-
1 200 200-
2 300 300
1 400 400-
2 100 100
PVAL will have only values either 1 or 2. I want to calculate PQUANT,PGROSS as below
PQUANT = (PQUANT WHEN PVAL IS 2)-(PQUANT WHEN PVAL IS 1) = 300-
PGROSS should be calculated sum of all pgross values=300-
Can some one help to combine these calculations in my above sql statement?
Thanks,
Donna.
---------------------------------
Be a better Globetrotter. Get better travel answers from someone who knows.
Yahoo! Answers - Check it out.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
