|
|
От: |
biochemist
|
https://www.anekdot.ru/i/caricatures/normal/20/7/27/1595846503.jpg |
| Дата: | 27.01.05 03:51 | ||
| Оценка: | |||
update Table1 A
Set ....
Where (field1, field2, field3) in (Select B.field1, B.field2, max(B.field3)
From Table1 B
Where b.field1 = a.field1
and b.field2 = a.field2)