Project

General

Profile

1
column doctype format a50;
2
SELECT doctype, count(*) cnt 
3
  FROM xml_documents 
4
 WHERE doctype IN (
5
           'eml://ecoinformatics.org/eml-2.0.1',
6
           '-//ecoinformatics.org//eml-dataset-2.0.0beta4//EN',
7
           '-//ecoinformatics.org//eml-dataset-2.0.0beta6//EN',
8
           'eml://ecoinformatics.org/eml-2.0.0'
9
       )
10
 GROUP BY doctype 
11
 ORDER BY cnt DESC
12
/
(8-8/30)