Query
Ola pessoal, estou apanhando aqui apos muitos anos sem mexer com DB.
Tenho uma tabela com os seguintes resultados
0000001
08:38:57.713
Reliability Ok
0000001
08:40:32.518
Reliability Ok
0000002
08:38:57.920
Reliability Ok
0000002
08:40:32.922
Reliability Ok
0000003
08:38:58.188
Reliability Ok
0000003
08:40:52.828
Reliability Ok
0000004
08:38:58.002
Reliability Ok
0000004
08:40:34.577
Reliability Ok
0000005
08:38:58.083
Reliability Ok
0000005
08:40:32.973
Reliability Ok
0000477
08:39:07.684
Reliability Ok
0000477
08:41:12.927
Reliability Ok
0000478
08:39:10.069
Reliability Ok
0000478
08:41:03.571
Reliability Ok
0000479
08:39:10.977
Reliability Ok
0000479
08:40:57.325
Reliability Ok
0000479
08:41:14.186
Reliability Ok
0000480
08:39:10.838
Reliability Ok
0000480
08:40:57.227
Reliability Ok
0000480
08:41:21.001
Reliability Ok
0000481
08:39:06.941
Reliability Ok
0000481
08:40:56.915
Reliability Ok
0000481
08:41:21.083
Reliability Ok
0000482
08:38:53.650
Gunshot generated passing
Como contar o numero de linhas removendo as linhas repetidas? No exemplo acima a consulta SQL deveria retornar 11, que sao o numero de linhas removendo as repetidas (da primeira coluna).
Discussão (1)
Carregando comentários...