blob: c0debae4be343074b8162ad0f36b256e4ef811bb (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
use plato;
$ou = select * from Input;
$a = select * from $ou where key > '0';
insert into @a
select * from $a order by key;
select * from $ou
where subkey > "0"
and key not in compact (select key from $a)
order by key;
|