select LOWER(RECID) as RECID, Count(RECID)
from seecdba.mv_myday_attendance
group by LOWER(RECID)
having count(RECID) > 1

"RECID","COUNT(RECID)"
"501722826135assessment tracking2y01s2013-2014",2
"501814816126ual l3 dip photography2y01s2013-2014",3
"501726226135assessment tracking2y01s2013-2014",2
"501455446126ual l3 dip photography3y01s2013-2014",2
"501753216135tutorial2y01s2013-2014",2
"501767096126ual l3 dip photography3y01s2013-2014",3
"501791806135assessment tracking2y01s2013-2014",2
"501582356135tutorial2y01s2013-2014",2
"501778816126ual l3 dip photography2y01s2013-2014",2
"501760056135assessment tracking2y01s2013-2014",2
"501454996135assessment tracking2y01s2013-2014",2
"501725566135assessment tracking2y01s2013-2014",2
"501590336135tutorial2y01s2013-2014",2
"501431386135assessment tracking2y01s2013-2014",2
"501754106126ual l3 dip photography2y01s2013-2014",3
"501820196126ual l3 dip photography3y01s2013-2014",2
"501733736126ual l3 dip photography2y01s2013-2014",2
"501767526126ual l3 dip photography2y01s2013-2014",2
"501720696126ual l3 dip photography2y01s2013-2014",2
"501743726126ual l3 dip photography2y01s2013-2014",2
"501730666135assessment tracking2y01s2013-2014",2
"501730696135assessment tracking2y01s2013-2014",2
"501583776135assessment tracking2y01s2013-2014",2
"501767246126ual l3 dip photography2y01s2013-2014",2
"501724156135assessment tracking2y01s2013-2014",2
"501723456126ual l3 dip photography2y01s2013-2014",2
"501787526126ual l3 dip photography2y01s2013-2014",2
"501730736126ual l3 dip photography1y01s2013-2014",2
"501741146135assessment tracking2y01s2013-2014",2
"501621446126ual l3 dip photography2y01s2013-2014",3
"501767286126ual l3 dip photography2y01s2013-2014",3
"501742746126ual l3 dip photography3y01s2013-2014",2
"501767096126ual l3 dip photography2y01s2013-2014",3
"501760056135tutorial2y01s2013-2014",2
"501588586126ual l3 dip photography1y01s2013-2014",2
"501767526126ual l3 dip photography3y01s2013-2014",2
"501760586135assessment tracking2y01s2013-2014",2
"501730696135tutorial2y01s2013-2014",2
"501641956126ual l3 dip photography3y01s2013-2014",2
"501493226126ual l3 dip photography2y01s2013-2014",3
"501725346126ual l3 dip photography2y01s2013-2014",3
"501753216135assessment tracking2y01s2013-2014",2
"501632616126ual l3 dip photography3y01s2013-2014",2
"501766296135tutorial2y01s2013-2014",2
"501765236135assessment tracking2y01s2013-2014",2
"501720816135tutorial2y01s2013-2014",2
"501473976135assessment tracking2y01s2013-2014",2
"501736176135tutorial2y01s2013-2014",2
"501766296135assessment tracking2y01s2013-2014",2
"501730666135tutorial2y01s2013-2014",2
"501725346126ual l3 dip photography3y01s2013-2014",2
"501767246126ual l3 dip photography3y01s2013-2014",2
"501791376126ual l3 dip photography2y01s2013-2014",3
"501400806126ual l3 dip photography2y01s2013-2014",3
"501725346126ual l3 dip photography1y01s2013-2014",2
"501791386135assessment tracking2y01s2013-2014",2
"501794376135assessment tracking2y01s2013-2014",2
"501723416126ual l3 dip photography3y01s2013-2014",2
"501724706135tutorial2y01s2013-2014",2
"501455446126ual l3 dip photography2y01s2013-2014",2
"501426546135tutorial2y01s2013-2014",2
"501556256135tutorial2y01s2013-2014",2
"501793896126ual l3 dip photography3y01s2013-2014",3
"501755556126ual l3 dip photography2y01s2013-2014",3
"501735106135assessment tracking2y01s2013-2014",2
"501722886135tutorial2y01s2013-2014",2
"501756376135tutorial2y01s2013-2014",2
"501730576126ual l3 dip photography2y01s2013-2014",3
"501712596126ual l3 dip photography3y01s2013-2014",2
"501742916126ual l3 dip photography3y01s2013-2014",2
"501659566135tutorial2y01s2013-2014",2
"501767486135tutorial2y01s2013-2014",2
"501742746126ual l3 dip photography2y01s2013-2014",2
"501732976135assessment tracking2y01s2013-2014",2
"501745496135tutorial2y01s2013-2014",2
"501806486126ual l3 dip photography2y01s2013-2014",3
"501483196126ual l3 dip photography1y01s2013-2014",2
"501787526126ual l3 dip photography3y01s2013-2014",2
"501790496135tutorial2y01s2013-2014",2
"501814816126ual l3 dip photography3y01s2013-2014",3
"501741146135tutorial2y01s2013-2014",2
"501735106135tutorial2y01s2013-2014",2
"501563126126ual l3 dip photography2y01s2013-2014",3
"501749266135assessment tracking2y01s2013-2014",2
"501765236135tutorial2y01s2013-2014",2
"501431386135tutorial2y01s2013-2014",2
"500713716135assessment tracking2y01s2013-2014",2
"501754106126ual l3 dip photography3y01s2013-2014",2
"501760586135tutorial2y01s2013-2014",2
"501918376135tutorial2y01s2013-2014",2
"501722826135tutorial2y01s2013-2014",2
"501916046135assessment tracking2y01s2013-2014",2
"501754106126ual l3 dip photography1y01s2013-2014",2
"501839726135assessment tracking2y01s2013-2014",2
"501787886135tutorial2y01s2013-2014",2
"501727566126ual l3 dip photography3y01s2013-2014",2
"501722056135assessment tracking2y01s2013-2014",2
"501729216126ual l3 dip photography3y01s2013-2014",2
"501732976135tutorial2y01s2013-2014",2
"501588586126ual l3 dip photography3y01s2013-2014",2
"501914826135assessment tracking2y01s2013-2014",2
"501791806135tutorial2y01s2013-2014",2
"501900846135tutorial2y01s2013-2014",2
"501730576126ual l3 dip photography1y01s2013-2014",2
"501741156126ual l3 dip photography2y01s2013-2014",3
"501726226135tutorial2y01s2013-2014",2
"501755556126ual l3 dip photography3y01s2013-2014",3
"501790496135assessment tracking2y01s2013-2014",2
"501742916126ual l3 dip photography2y01s2013-2014",3
"501900476135tutorial2y01s2013-2014",2
"501769636126ual l3 dip photography2y01s2013-2014",2
"501720696126ual l3 dip photography3y01s2013-2014",2
"501564866135assessment tracking2y01s2013-2014",2
"501770026126ual l3 dip photography2y01s2013-2014",3
"501722736135tutorial2y01s2013-2014",2
"501776276126ual l3 dip photography3y01s2013-2014",2
"501767486135assessment tracking2y01s2013-2014",2
"501916346135assessment tracking2y01s2013-2014",2
"501914826135tutorial2y01s2013-2014",2
"501730576126ual l3 dip photography3y01s2013-2014",2
"501723416126ual l3 dip photography1y01s2013-2014",2
"501741076135tutorial2y01s2013-2014",2
"501743726126ual l3 dip photography3y01s2013-2014",2
"501564866135tutorial2y01s2013-2014",2
"501844246135assessment tracking2y01s2013-2014",2
"501641956126ual l3 dip photography2y01s2013-2014",2
"501450856135assessment tracking2y01s2013-2014",2
"501582356135assessment tracking2y01s2013-2014",2
"501749266135tutorial2y01s2013-2014",2
"501741416126ual l3 dip photography3y01s2013-2014",3
"501745476126ual l3 dip photography2y01s2013-2014",2
"500713716135tutorial2y01s2013-2014",2
"501400806126ual l3 dip photography3y01s2013-2014",3
"501756376135assessment tracking2y01s2013-2014",2
"501722886135assessment tracking2y01s2013-2014",2
"501597986126ual l3 dip photography3y01s2013-2014",2
"501741156126ual l3 dip photography3y01s2013-2014",3
"501745496135assessment tracking2y01s2013-2014",2
"501556256135assessment tracking2y01s2013-2014",2
"501597986126ual l3 dip photography2y01s2013-2014",2
"501729216126ual l3 dip photography2y01s2013-2014",3
"501582266135tutorial2y01s2013-2014",2
"501067576135assessment tracking2y01s2013-2014",2
"501724156135tutorial2y01s2013-2014",2
"501730736126ual l3 dip photography3y01s2013-2014",2
"501913396126ual l3 dip photography2y01s2013-2014",2
"501791386135tutorial2y01s2013-2014",2
"501067576135tutorial2y01s2013-2014",2
"501755786135assessment tracking2y01s2013-2014",2
"501730196126ual l3 dip photography3y01s2013-2014",3
"501794376135tutorial2y01s2013-2014",2
"501621446126ual l3 dip photography3y01s2013-2014",3
"501483196126ual l3 dip photography3y01s2013-2014",2
"501767286126ual l3 dip photography3y01s2013-2014",3
"501820196126ual l3 dip photography1y01s2013-2014",2
"501588586126ual l3 dip photography2y01s2013-2014",3
"501404706126ual l3 dip photography2y01s2013-2014",3
"501723416126ual l3 dip photography2y01s2013-2014",3
"501916346135tutorial2y01s2013-2014",2
"501769886135tutorial2y01s2013-2014",2
"501900846135assessment tracking2y01s2013-2014",2
"501844246135tutorial2y01s2013-2014",2
"501493226126ual l3 dip photography3y01s2013-2014",3
"501839726135tutorial2y01s2013-2014",2
"501473976135tutorial2y01s2013-2014",2
"501741076135assessment tracking2y01s2013-2014",2
"501730736126ual l3 dip photography2y01s2013-2014",3
"501900476135assessment tracking2y01s2013-2014",2
"501641956126ual l3 dip photography1y01s2013-2014",2
"501745476126ual l3 dip photography3y01s2013-2014",2
"501791376126ual l3 dip photography3y01s2013-2014",2
"501729216126ual l3 dip photography1y01s2013-2014",2
"501722056135tutorial2y01s2013-2014",2
"501767256135assessment tracking2y01s2013-2014",2
"501787886135assessment tracking2y01s2013-2014",2
"501917496135assessment tracking2y01s2013-2014",2
"501917496135tutorial2y01s2013-2014",2
"501404706126ual l3 dip photography3y01s2013-2014",3
"501723456126ual l3 dip photography3y01s2013-2014",2
"501632616126ual l3 dip photography2y01s2013-2014",2
"501483196126ual l3 dip photography2y01s2013-2014",3
"501720816135assessment tracking2y01s2013-2014",2
"501913396126ual l3 dip photography3y01s2013-2014",2
"501583776135tutorial2y01s2013-2014",2
"501820196126ual l3 dip photography2y01s2013-2014",3
"501791376126ual l3 dip photography1y01s2013-2014",2
"501563126126ual l3 dip photography3y01s2013-2014",3
"501806486126ual l3 dip photography3y01s2013-2014",3
"501426546135assessment tracking2y01s2013-2014",2
"501769886135assessment tracking2y01s2013-2014",2
"501918376135assessment tracking2y01s2013-2014",2
"501659566135assessment tracking2y01s2013-2014",2
"501730196126ual l3 dip photography2y01s2013-2014",3
"501416116126ual l3 dip photography3y01s2013-2014",3
"501722736135assessment tracking2y01s2013-2014",2
"501727566126ual l3 dip photography1y01s2013-2014",2
"501916046135tutorial2y01s2013-2014",2
"501582266135assessment tracking2y01s2013-2014",2
"501450856135tutorial2y01s2013-2014",2
"501778816126ual l3 dip photography3y01s2013-2014",2
"501767256135tutorial2y01s2013-2014",2
"501741416126ual l3 dip photography2y01s2013-2014",3
"501776276126ual l3 dip photography2y01s2013-2014",2
"501590336135assessment tracking2y01s2013-2014",2
"501793896126ual l3 dip photography2y01s2013-2014",3
"501746176126ual l3 dip photography2y01s2013-2014",2
"501712596126ual l3 dip photography2y01s2013-2014",2
"501746176126ual l3 dip photography3y01s2013-2014",2
"501727566126ual l3 dip photography2y01s2013-2014",3
"501770026126ual l3 dip photography3y01s2013-2014",3
"501416116126ual l3 dip photography2y01s2013-2014",3
"501755786135tutorial2y01s2013-2014",2
"501733736126ual l3 dip photography3y01s2013-2014",2
"501454996135tutorial2y01s2013-2014",2
"501725566135tutorial2y01s2013-2014",2
"501742916126ual l3 dip photography1y01s2013-2014",2
"501724706135assessment tracking2y01s2013-2014",2
"501736176135assessment tracking2y01s2013-2014",2