var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
using oracle, im trying to find records that have more than 1 corresponding record in teh same table if that makes any sense at all..
a query such as:
i was thinking something like select field1, count(field2) from table where count(field2) > 1 group by field1
it should be a 1:1 field1:field2 but theres reason to believe field2's are not unique..
Thanks in advance
You need to group by field2 as well for the count to work properly.
select field1, count(field2) as counter
Group By field1
Having counter > 1