I have a table "employee" having the following data:
id name 1 subhajit 2 ramesh 3 SuBhajit
I want to find the duplicate rows in the table. Thus I need a query which will return
id name 1 subhajit 3 SuBhajit
Note that two "subhajit" are of different cases.
Please help me write the query. Thanks in advance.