We have a table called TEST that contains two fields i.e. REG_NO and PAYMENT. Now problem is some REG_NO contains three type of PAYMENT i.e. 1,1 1,2 1,3 and some REG_NO contains only one type of PAYMENT i.e. 1,1. I want to select only those records that have only one type of PAYMENT. I need to require SQL Queury for this problem Please help me. I shall be very thankful to you.