Questions tagged as 'distinct'

Could anyone help me with this problem? The following query throws the following error:    # 1054 - Unknown column 'u.idocorrence' in 'where clause' SELECT DISTINCT * FROM( (SELECT o.*, u.nome AS requerente FROM ocorrencia o, util...

Hello, I'm having problems with a query, and I need to bring only the last record of each id_face that has in the imagens table, but for some reason it's causing id_faces duplicates Follow my query: SELECT DISTINCT(...

Good afternoon guys. link I need a help, I tried to see in the session above but I could not solve my problem. My problem is as follows, I need to make a selection of products and all of them separated by vendor, for example. Imagi...

I'm trying to make a query that aggregates all the results in a single line, ie, does not bring duplicate results. I've already used distinct and group by but none of the two returned me what I need. My query is as follows:...

I need to make a selection that will bring the last users who logged in without repeating the names. The problem is that the command below first groups and then sorts: SELECT usuario FROM tab_logins GROUP BY usuario ORDER BY data_login desc...