I am developing an app with input field, and for pattern using angular js ui-mask. 

**HTML**

```
<input type="tel" class="input-field " data-ng-model="registrationField.debitcard" ui-mask="9999    9999    9999    9999" placeholder="Enter ATM/Debit Card Number"  ui-mask-placeholder ui-mask-placeholder-char="space" id="debitCardFld" ui-options="{clearOnBlur: false}"/>

```

1. With `type="text"` the code works fine.
2. But when we use `type="password"`, on `focus` of the field, the **spaces** in `pattern` is also masked.

Only when the user types, it has to mask the characters.

Is there any way to achieve it?

Ref: <https://github.com/angular-ui/ui-mask>
['https://Stackoverflow.com/questions/41422231', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/2979319/']
You can use conditional aggregation for this:

```
SELECT column1,
  column2
FROM your_table t
GROUP BY column1,
  column2
HAVING COUNT(CASE WHEN source = 'a' THEN 1 END) = 0;

```
You can achieve the desired result using below query:

SELECT DISTINCT COLUMN1, COLUMN2
FROM TABLE1
WHERE Source <> 'a'