如果你的表中有ID号 则可以用下面的方法实现: update table1 set 占用否='占用' where id in (select id, min(铺号) from table1 where 等级='二等' and 占用否='未')
update tmptest set 占用否='占用' from (select 等级, 占用否, min(铺号) as 铺号 from tmptest where 等级='二等' and 占用否='未' group by 等级, 占用否) x where tmptest.等级=x.等级 and tmptest.铺号=x.铺号 and tmptest.占用否=x.占用否
UPDATE tablename SET 占用否='占用' WHERE 等级='二级' AND 占用否='未' AND 铺号=(SELECT MIN(铺号) FROM tablename WHERE 等级='二级' AND 占用否='未')这样的语句interbase应该能够执行的.
update tablename set 占用否='占用' from tablename a right join ( select 等级,min(铺号) as 铺号,占用否 from tablename where 等级='二' and 占用否='未' ) b on a.等级=b.等级 and a.铺号=b.铺号 and a.占用否=b.占用否
我写我的出来! UPDATE A SET 占用否 = '占用' WHERE (占用否 = '未') AND (等级 = '二等') AND (铺号 = (SELECT MIN(铺号) AS 最小铺号 FROM A WHERE (占用否 = '未') AND (等级 = '二等') AND (占用否 = '未') AND (等级 = '二等')))WinXp Pro+Sp2+SQL Server 2000通过
则可以用下面的方法实现:
update table1 set 占用否='占用'
where id in (select id, min(铺号) from table1 where 等级='二等' and 占用否='未')
from (select 等级, 占用否, min(铺号) as 铺号 from tmptest where 等级='二等' and 占用否='未'
group by 等级, 占用否) x
where tmptest.等级=x.等级 and tmptest.铺号=x.铺号 and tmptest.占用否=x.占用否
那就分两步吧,先select 再 update.
WHERE 等级='二级' AND 占用否='未' AND 铺号=(SELECT MIN(铺号) FROM tablename WHERE 等级='二级' AND 占用否='未')这样的语句interbase应该能够执行的.
from tablename a
right join (
select 等级,min(铺号) as 铺号,占用否
from tablename
where 等级='二' and 占用否='未'
) b
on a.等级=b.等级 and a.铺号=b.铺号 and a.占用否=b.占用否
UPDATE A
SET 占用否 = '占用'
WHERE (占用否 = '未') AND (等级 = '二等') AND (铺号 =
(SELECT MIN(铺号) AS 最小铺号
FROM A
WHERE (占用否 = '未') AND (等级 = '二等') AND (占用否 = '未') AND
(等级 = '二等')))WinXp Pro+Sp2+SQL Server 2000通过