Viewing 2 posts - 1 through 2 (of 2 total)
My actual query is:
here Name is the fieldName and Employee is the TableName;
SELECT Name FROM Employee GROUP BY Name HAVING ( COUNT(Name) >= 1 );
From this query I got the...
December 21, 2011 at 5:19 am
#1424149
I get this by the following query:
SELECT Column_Name FROM TableName GROUP BY Column_Name HAVING ( COUNT(Column_Name) >= 1 );
December 21, 2011 at 5:09 am
#1424143