Ok, I need one more complicated query. I need to find all duplicate strings in a particular field of the table. The test should be case insensetive, since the table wouldn't contain two exact matches, however it may contain case insensetive matches.
One thing would be to write nested query:
select userid as user1 from table ABC where lower(userid) = lower(select userid as user2 from ABC where user1 != user2)
Now, I'm not sure this will work at all, especiall the second lower(...) part. Any suggestions?
One thing would be to write nested query:
select userid as user1 from table ABC where lower(userid) = lower(select userid as user2 from ABC where user1 != user2)
Now, I'm not sure this will work at all, especiall the second lower(...) part. Any suggestions?