Re: all the table values equal

Oliveiros d'Azevedo Cristina ha scritto:
>
> OK, So, analysing your new question, the time interval is still
> important? Or no longer?

It's important but simple to translate into sql, so I remove it from my
question.

> So writting your query in english : "I want all users that don't change
> "value" and their value is equal to x ?"
>

Yes. All the users that have only one value into the "value" column and
that value is NN.

> Or will you need to find all the users that don't change value with just
> one query? And the query would return something like
>
> id_user | value
> 2 | -1
> 4| 3
>

A right result for me, based by my data, will be:

// choosing -1 like value
id_user
2

// choosing 3 like value
id_user
4

and if I add to the table:
id_user | value | datetime
5 | -1 | xxx
5 | -1 | xxx +1

// choosing -1 like value
id_user
2
5

Thanks,
Michele