Most voted "distinct" questions
21 questions
Sort by count of
-
4
votes1
answer1365
viewsCountdown in two tables
I’m having trouble counting items pertaining to neighborhoods. I need to list all the neighborhoods of the city X and show the items available cars and motorcycles. In the example I only used one…
-
4
votes1
answer1453
viewsDoubt in the method of using Distinct and Count together!
I have a requested table as the example below: Id | Cliente | Status 1 | XPTO | Proposta 2 | ABCD | Proposta 3 | XPTO | Venceu 4 | XPTO | Perdeu And I want to present a result like this: Cliente |…
-
4
votes1
answer784
viewsSelect the first row of each group in Mysql
Suppose I have such a table: item | group -------+-------- item a | group x item b | group y item c | group y item d | group x item e | group z And that I want to select a single item to represent…
-
2
votes1
answer3058
viewsSQL distinct with sum
Hello, I have a problem making a sum in a query. Example and query results: select DISTINCT t.ID, t.nomeuc as "Nome UC", t.tipoturno as "Tipo Turno", a.num_presencas as "Número de Presenças" from…
-
2
votes0
answers54
viewsmysql if - how to apply to equal records
Hello! staff I am trying to select and apply a rule only in equal records. I need all records to be listed, but in those that are equal, a specific rule is applied; For example, select all client…
-
2
votes2
answers127
viewsSearch last access record with MYSQL
Suppose I have the table clientes: -------------------------------------- | ID| Cliente | Data_Registro | |------------------------------------- | 7 | Joaquim | 2019-07-17 09:45:00 |…
-
1
votes1
answer327
viewsSelect Distinct
tbl_protocolos id_protocolo | protocolo | assunto 1;ra001;vazamentos 2;ra002;incendios 3;ra003;inundacoes tbl_prot_tramitacoes id_tram | id_protocolo | pdf | id_setor_origem 1;1;001.pdf;70…
-
1
votes2
answers389
viewsMD5 is good enough?
I’m working on a legacy system, which has a database with about five years of accumulated records with no normalization. Among other things, its purpose is to allow users to write and post posts in…
-
1
votes1
answer703
viewsSearch last record of a distinct group
I’m developing a small vaccine control system and I’m having a hard time executing a select. I have a record of dogs, other types of vaccines and a third of dog vaccine, where I group the dog’s id,…
-
1
votes1
answer225
viewsselect distinct in temporal table sql server
I have the following code: (is from a table that the representatives have the same code, which generates duplicated values, I solve this by taking the most current representative, in short the last…
-
0
votes1
answer440
viewsSelect Union same table
Could anyone help me with this problem? The query below throws the following error: #1054 - Unknown column 'u.idocorrencia' in 'Where clause' SELECT DISTINCT * FROM( (SELECT o.*, u.nome AS…
-
0
votes1
answer688
viewsUse DISTINCT SQL Server clause
Hi, I need some help ! I need to do a query and bring in the Nifs without repeating. I do it like this: SELECT DISTINCT NIF FROM CustomerRegistrations But I also want to bring more columns from this…
-
0
votes1
answer100
views -
0
votes1
answer82
viewsselect return results without repeating reply
I have the following query SELECT (SUM(DISTINCT result)/COUNT(*))as total, uf FROM users WHERE result > 0 and result IS NOT NULL GROUP BY uf ORDER BY total DESC LIMIT 5 I want to select all 5…
-
0
votes2
answers719
viewsBring repeat records from 3 columns in the same table
I have a table with transport voucher data of my company employees: nome ! valor1 ! valor2 ! valor3 teste1 ! 6.50 ! 0.00 ! 0.00 teste2 ! 4.30 ! 2.80 ! 1.10 teste3 ! 8.40 ! 1.10 ! 0.00 teste4 ! 2.85…
-
0
votes1
answer668
viewsMysql - Sort before grouping
I need to make a selection that brings 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…
-
0
votes1
answer330
views -
0
votes2
answers517
viewsSelection top 3 Where distinct
Good afternoon, you guys. https://stackoverflow.com/questions/1925176/sql-server-2008-top-10-and-distinct-together I need a help, I tried to see in the above section but could not solve my problem.…
-
0
votes2
answers408
viewsHow to use distinct to bring a single result of each Dart/Flutter item
Hello, I am trying to bring a single result of each consuming title from an API. As this picture shows I’m having repeated titles What way could I make it right, it follows code as far as I’ve tried…
-
0
votes3
answers721
viewsSelect Distinct is bringing duplicate Mysql data
I need to bring only the last record of each id_face that has in the table imagens, but for some reason it’s bringing id_faces duplicates. Follow my consultation: SELECT DISTINCT(i.id_face) as…
-
0
votes1
answer32
viewsDISTINCT in a WHERE Oracle
I need to return the last two purchases of each table item NOTA_FISCAL_ENTRADA_ITEM, but returns column values VL_UNITARIO_ENTRADA_EST different. That is, if in the last two purchases the value is…