内连接自连接和内嵌自连接的区别
摘要：
select (SELECT count(1)FROM entity.PhysicalItemResult sub,entity.PhysicalItemResult main WHERE sub.physicalitemid = main.physicalitemid AND sub.physicalitemresultid <= main.physicalitemresultid) as '序号',physicalitemid,physicalitemresultidfrom entity.PhysicalItemResult--------------------- 阅读全文
posted @ 2012-11-27 15:00 小僷 阅读(152) 评论(0) 推荐(0)
浙公网安备 33010602011771号