Revision 13095
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/NY/validations.sql | ||
|---|---|---|
| 322 | 322 |
-- |
| 323 | 323 |
|
| 324 | 324 |
CREATE VIEW _specimens_16_list_distinct_specimen_descriptions AS |
| 325 |
SELECT "Ecatalog_all"."specimenDescription" |
|
| 325 |
SELECT DISTINCT "Ecatalog_all"."specimenDescription"
|
|
| 326 | 326 |
FROM "Ecatalog_all" |
| 327 | 327 |
WHERE ("Ecatalog_all"."specimenDescription" IS NOT NULL);
|
| 328 | 328 |
|
Also available in: Unified diff
fix: inputs/NY/validations.sql: _specimens_16_list_distinct_specimen_descriptions: removed duplicated rows using DISTINCT