22:54
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] delete to leave x rows per group
RB Smissaert <[EMAIL PROTECTED]>
wrote:
> Can this be done in SQLite SQL?
>
> ID Value
> ---
> 1 A
> 1 B
> 1 C
> 1 D
> 1 E
> 2 A
> 2 B
> 2 C
> 2 D
> 2
RB Smissaert <[EMAIL PROTECTED]>
wrote:
> Can this be done in SQLite SQL?
>
> ID Value
> ---
> 1 A
> 1 B
> 1 C
> 1 D
> 1 E
> 2 A
> 2 B
> 2 C
> 2 D
> 2 E
> 2 F
>
> Delete rows to leave x rows per ID, say 3 rows, so we get:
delete from tableName where rowid not in (
select rowid
Can this be done in SQLite SQL?
ID Value
---
1 A
1 B
1 C
1 D
1 E
2 A
2 B
2 C
2 D
2 E
2 F
Delete rows to leave x rows per ID, say 3 rows, so we get:
ID Value
---
1 C
1 D
1 E
2
3 matches
Mail list logo
