RE: [U2] How do we get unique records from Universe file(Table)

[Ray Wurlod]

Or, if you're after the records for which there is only one instance

SELECT columnlist, COUNT(*) FROM filename GROUP BY columnlist HAVING COUNT(*) = 1;
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/