Record | SQL Expression | SQL Type |
EH | from ( select count(*) as NoRecs, max(LineNumber) as LineNumber from ( SELECT Country, Institute, Year, Survey, Ship, min(linenumber) as LineNumber FROM REH GROUP BY Country, Institute, Year, Survey, Ship) as N having count(*) > 1) as REH | Free SQL |