sql面试题
-- 1
SELECT * FROM SALORDER SA JOIN GCODE GC ON GC.GCODE=SA.GCODE WHERE gc.gname='商品1' ;
-- 2 id, gc.gcode,qty,rmb,odate,gname,type
select id, gc.gcode,qty,rmb,odate,gname,type from
PURORDER PU , GCODE GC ,
(SELECT count(*) as sum FRO..
原创
2022-03-02 16:16:40 ·
171 阅读 ·
0 评论