select distinct values from multiple coloumn.

Question

I am performing a SQL join query but getting duplicate values in a row tried to group by but didn't work

My SQL query is
SELECT SALES.BILL_NO , CUSTOMERS.NAME , SALES.DATE FROM SALES JOIN CUSTOMERS ON SALES.CUST_ID = CUSTOMERS.ID

above query looks like this:-
BILL_NO NAME DATE

10 NIRANJAN 2021-02-16 15:43:54.184
10 NIRANJAN 2021-02-16 15:43:54.203
11 MMM 2021-02-16 16:07:55.773
12 MMM 2021-02-16 22:06:35.165
12 MMM 2021-02-16 22:06:35.166

what I want is to select only unique BILL_NO.

Answer 1

Read about "DISTINCT"

Answer 2

Hima wasn't working.. after that i googled tried many things but nothing works.