Skip to content

Commit 20f2803

Browse files
committed
suppression erreur readLine() ligne incomplète
1 parent 8bf283d commit 20f2803

2 files changed

Lines changed: 5 additions & 5 deletions

File tree

‎index.qmd‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -25,6 +25,6 @@ about:
2525

2626
I'm interested in spatial statistics ... or maybe not ?
2727

28-
[هَـٰذَا كَلَامٌ عَرَبِيٌّ.]{lang="ar"}
28+
[.هَـٰذَا كَلَامٌ عَرَبِيٌّ]{lang="ar"}
2929

3030
:::

‎posts/20240107_doublons_sql/index.qmd‎

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -23,7 +23,7 @@ Nous pouvons identifier les doublons comme suit :
2323
--| eval: false
2424
SELECT elu_nom, elu_prenom, elu_date_naissance, elu_lieu_naissance, elu_genre, COUNT(*) FROM elu
2525
GROUP BY elu_nom, elu_prenom, elu_date_naissance, elu_lieu_naissance, elu_genre
26-
HAVING COUNT(*) > 1;
26+
HAVING COUNT(*) > 1;
2727
```
2828

2929
::: {.callout-note collapse="false"}
@@ -45,7 +45,6 @@ WHERE e1.elu_nom = e2.elu_nom
4545
AND e1.elu_lieu_naissance = e2.elu_lieu_naissance
4646
AND e1.elu_genre = e2.elu_genre
4747
AND e1.elu_id < e2.elu_id;
48-
4948
```
5049

5150
::: {.callout-important collapse="false"}
@@ -70,6 +69,7 @@ CREATE TABLE IF NOT EXISTS new_elu (
7069
elu_genre genre NOT NULL
7170
);
7271
```
72+
7373
- copier une version unique de chaque enregistrement
7474

7575
a. première méthode
@@ -82,7 +82,7 @@ SELECT elu_nom, elu_prenom, elu_date_naissance, elu_lieu_naissance, elu_genre
8282
FROM elu
8383
GROUP BY elu_nom, elu_prenom, elu_date_naissance, elu_lieu_naissance, elu_genre;
8484
```
85-
85+
8686
b. deuxième méthode avec DISTINCT
8787

8888
```{sql}
@@ -169,4 +169,4 @@ result <- RPostgres::dbGetQuery(
169169
ORDER BY elu_genre, elu_nom, elu_prenom;")
170170
171171
print(result)
172-
```
172+
```

0 commit comments

Comments
 (0)