SQL Search - Results not duplicated

Question

I am wanting to return a database query without repeated data. The table is called Wps_history and contains the following columns:

id
user_id
adm_user_id
type
user
lancamento
data
valor
saldo
reason
ip
inserted   

I’m doing the research as follows:

select * 
from wps_history 
where inserted between "2016-11-01 00:00:00" AND "2016-11-30 23:59:59";

Only I’m getting duplicate user data, what I need to do is filter the result by user_id.

Answer 1

You need to use the clause DISTINCTwith the column you want the single die:

select DISTINCT(user_id) from wps_history where inserted between "2016-11-01 00:00:00" AND "2016-11-30 23:59:59"