查询问题(50分)

比如　某张表中有２个字段　lsh(流水号) 、invoice_no (票据号)　票据号是唯一索引<br>但是一张票据号可以对应多个流水号，问题如下<br>怎么查询出　票据号对应的流水号大于２的记录　例如　票据号２３０２０００　对应的流水号为　０８０５２８００００１和０８０５２８００００２　这张票据存储了２比流水记录。　<br>查询结果<br>　　　lsh &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; invoice_no<br>０８０５２８００００１　　　　　　２３０２０００<br>０８０５２８００００２　　　　　　２３０２０００　　

select a.* from table1 a,<br>(select invoice_no, count(lsh) as invoice_count from table1 group by invoice_no having count(lsh)&gt;=2) b<br>where a.invoice_no=b.invoice_no

谢谢 Corn3