ICES Marine Data
News
Events
Calendar
Library
SharePoint Login
Admin
About ICES
Who we are
How we work
Global cooperation
Project collaborations
ICES Awards
Jobs at ICES
Science
Expert groups
Science priorities
Publications
Data
Dataset Collections
Data Portals
Data Tools
Assessment Tools
Maps
Vocabularies
Guidelines and Policy
Advice
Latest advice
Ecosystem overviews
Fisheries overviews
ICES ecosystems and advisory areas
Join us
Why join us
Join our expert groups
Become an observer
Join our advisory process
Dataset Collections
Data Portals
Data Tools
Assessment Tools
Maps
Vocabularies
Guidelines and Policy
DATSU
DATSU
>
List of operations
>
Specification of the format
> Details of the check
Details of a check:
Record:
EC
Check Description:
Duplicate CampaignID is found in the Campaign records in the file
Error type:
error
Record
SQL Expression
SQL Type
EC
from REC where REC.LineNumber in (SELECT min (REC.LineNumber) as 'LineNumber' from REC GROUP BY REC.CampaignID HAVING COUNT(*) > 1)
Free SQL
International Council for the Exploration of the Sea (ICES) · Conseil International pour l'Exploration de la Mer (CIEM)
ICES Secretariat · H. C. Andersens Boulevard 44-46, DK 1553, Copenhagen Denmark · Tel: +45 3338 6700 · Fax: +45 3393 4215 ·
info@ices.dk
Disclaimer
© ICES - All Rights Reserved