当前位置：网站首页>Query the employee information of non business department employees who joined in 2021. Comrades, how to write SQL statements and solve them

Query the employee information of non business department employees who joined in 2021. Comrades, how to write SQL statements and solve them

2022-04-21 17:18:00 【CSDN Q & A】

The phenomenon and background of the problem
Problem related code , Do not paste screenshots
Operation results and error reporting contents
My solution ideas and tried methods
What I want to achieve


Take the answer ：

Create a data table comb; Then add employee information to the data table , Such as name , Gender , Whether it is an employee of the business department （ Column name is keyuan）： Employees of non business department are 0, The employees of the business department are 1：

select * in combwhere keyuan = 0

【MySQL】—— Basic introduction to database _ Fan San's blog -CSDN Blog

版权声明
本文为[CSDN Q & A]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204150210324940.html

边栏推荐

猜你喜欢

随机推荐