摘要:
今天写oracle语句时发现一个奇怪的问题,纠结了很久没有找到原因。求大牛解惑。问题精简如下:select seq,info ,topic from system.help where seq in (select distinct seq from system.help where seq=20); -----(1)与 select seq,info ,topic from system.help where seq in(20)------(2)所得的结果差距很大。众所周知select distinct seq from system.help where seq=20的结果当然是20。 阅读全文