AccessÖпÉÒÔ²åÈëʱ±È×îСֵСÓÚ1Âð£¿

ÎÒÕâÑùдδָÃ÷µÄ´íÎó£º
SQL code:
((select min(pview) from DSolution)-1)

---

select min(pview)-1 from DSolution

---

ÒýÓÃ

select min(pview)-1 from DSolution

Õý½â¡£

---

insert into table1 (myvale) select min(pview)-1 from DSolution

---

SELECT DICTINCT (SELECT MIN(pview)
from DSolution)-1 from DSolution
OR
select min(pview)-1 from DSolution

---

ÒýÓÃ

select min(pview)-1 from DSolution

¶àлÁË
ÕâÑùдΪʲô²»Ðа¡£º

SQL code:
insert into Dsolution(PID,PView) values(16,(select min(pview)-1 from DSolution))

---

insert into Dsolution(PID,PView)
select 16,min(pview)-1 from DSolution

---

Ŷ£¬ÊÔÏ£¬AccessÖв»ÖªµÀÕâÖÖÓï·¨Äܲ»ÄÜÓÃŶ

---

ÒýÓÃ

insert into Dsolution(PID,PView)
select 16,min(pview)-1 from DSolution

·Ç³£¸Ðл£¬