SQL查询语句的命令

发布网友发布时间：2022-04-26 02:57

共5个回答

热心网友时间：2022-06-20 07:09

1.select E.YGNAME 员工名,E.YGBH 编号,A.YGYX 月薪 from E,A where E.YGBH=A.YGBH
and E.YGBM='后勤部'

2.select E.* from E,A
    where E.YGBH=A.YGBH
    and A.YGYX between 10000 and 50000
    and A.NIAN=2007
    and A.YUE=7

热心网友时间：2022-06-20 07:09

1.SELECT E.YGBANE,E.YGBH,A.YGYX FROM E LEFT JOIN A ON E.YGBH=A.YGBH WHERE E.YGBM='后勤部' 2.SELECT E.YGNAME,E.YGBH,E.YGBM FROM E LEFT JOIN A ON E.YGBH=A.YGBH WHERE A.NIAN=2007 AND A.YUE=7 AND YGYX BETWEEN 10000 AND 50000

热心网友时间：2022-06-20 07:10

实例验证：

热心网友时间：2022-06-20 07:10

1) SELECT E.YGNAME as "员工名字"， E.YGBH as "编号"， A.YGYX as "月薪"
FROM E, A WHERE E.YGBH=A.YGBH
AND E.YGBM='后勤部'

2) select E.* from E,A
where E.YGBH=A.YGBH
and A.YGYX between 10000 and 50000
and A.NIAN=2007
and A.YUE=7

热心网友时间：2022-06-20 07:11

1:SELECT E.YGNAME,E.YGBH,A.YGYX FROM E JOIN A ON E.YGBH=A.YGBH
2:SELECT E.YGNAME,E.YGBH,A.YGBM FROM E JOIN A ON E.YGBH=A.YGBH WHERE A.YUE='七月' AND (A.YGYX>10000 AND A.YGYX<50000)