var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How To Return Rows with Duplicate Values?
I am fairly new to DB2, and can't figure out how to return a result set that shows me people with duplicate values in certain fields.
For example, my table has two differnet SSN fields
I want to see people who have two mbr_ssns in the table that are the same value. If I try count(mbr_ssn) > 1, it may return people with different mbr_ssn numbers.
Can anyone help?
i'm not sure i understand your question
HAVING COUNT(*) > 1