如果 Qid 的类型是varchar ,则可以用下面的select qid from paper where len(qid)<=(select min(len(qid)) from paper where isnull(qid,'')<>'') and pid=‘给定的pid’如果是text,呵呵 兄弟也没办法了,看那位大大指点 :)
select b.* from paper as b,(select mix(pid) from paper where pid='给定值') as a where b.qid=a.qid
兄弟也没办法了,看那位大大指点
:)
where b.qid=a.qid