1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| create table ligne_usinage (
um char(10) NOT NULL,
uc char(10) NOT NULL,
quand datetime default (getdate()),
sceau timestamp
)
go
insert ligne_usinage (um, uc) values ('S456789123', 'M987654321');
insert ligne_usinage (um, uc) values ('S345678912', 'M987654321');
insert ligne_usinage (um, uc) values ('S234567891', 'M987654321');
insert ligne_usinage (um, uc) values ('S123456789', 'M987654321');
insert ligne_usinage (um, uc) values ('S567891234', 'M987654321');
insert ligne_usinage (um, uc) values ('S678912345', 'M876543219');
insert ligne_usinage (um, uc) values ('S123456789', 'M987654321');
insert ligne_usinage (um, uc) values ('S234567891', 'M876543219');
select distinct uc from ligne_usinage where um like 'M987654321' order by sceau desc
go |
Partager