×
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.
WITH T1 AS (
select d.QEZDIRIDX, D.QEZDIRNAM1, SUM(o.QEZALCSIZE) AS SIZE
from routines.qaezd0014d d left outer join routines.qaezd0014o o ON
D.QEZDIRIDX=O.QEZDIRIDX
WHERE D.QEZDIRNAM1<>'/'
GROUP BY D.QEZDIRIDX, D.QEZDIRNAM1
ORDER BY D.QEZDIRIDX, D.QEZDIRNAM1)
SELECT * FROM T1
ORDER BY SIZE DESC;
I can refine it a little with a HAVING clause
WITH T1 AS (
select d.QEZDIRIDX, D.QEZDIRNAM1, SUM(o.QEZALCSIZE) AS SIZE
from routines.qaezd0014d d left outer join routines.qaezd0014o o ON
D.QEZDIRIDX=O.QEZDIRIDX
WHERE D.QEZDIRNAM1<>'/'
GROUP BY D.QEZDIRIDX, D.QEZDIRNAM1
HAVING SUM(O.QEZALCSIZE)>2000000000
ORDER BY D.QEZDIRIDX, D.QEZDIRNAM1)
SELECT * FROM T1
ORDER BY SIZE DESC;
WITH T1 AS (
select d.QEZDIRIDX, d.qezdirnam1, SUM(o.QEZALCSIZE) AS SIZE
from routines.qaezd0014d d left outer join routines.qaezd0014o o ON
D.QEZDIRIDX=O.QEZDIRIDX
WHERE D.QEZDIRNAM1<>'/'
GROUP BY D.QEZDIRIDX, D.QEZDIRNAM1
HAVING SUM(O.QEZALCSIZE)>2000000000
)
select t1.qezdirnam1,
o2.qezobjnam,o2.qezalcsize
from t1 left outer join routines.qaezd0014o o2
on t1.qezdiridx=o2.qezdiridx
where o2.qezalcsize>100000000
order by t1.qezdiridx, qezalcsize desc;
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
