SQL中参数的问题
一个sql语句中,要两次用到同一个参数的值,比如:
select * from table1 where ( name = :NAME) and (age = select max(age) from table1 where name = :NAME)
大概其就是这个意思,可却无法得到正确结果。如果换成形如:
select * from table1 where ( name = :NAME1) and (age = select max(age) from table1 where name = :NAME2)
写成两个参数就行了,求教各位大侠为什么会这样?