如何在表中查找具有多个角色的员工 [英] how to find a employee with multiple role in table

问题描述

嗨朋友
我有一个名为emp 的表，其中有2列

hi friends
i have table called emp which has 2 columns

1. emp_name
2. role

我想要的是，我想在单个SQl语句中找到角色为A和B的员工

我试过了

what i want is, i want to find employees with role A and B in single SQl statement

I tried

SELECT * FROM EMP WHERE ROLE LIKE ''A'' AND ROLE LIKE ''B''

但它不起作用，任何想法该怎么做
我要避免使用游标.

在此先感谢

but its not working, any idea how to do it
i wana avoid use of cursor.

thanks in advance

推荐答案

在where语句中使用OR或IN

Use OR or IN in where statement

SELECT * FROM EMP WHERE ROLE LIKE 'A' OR ROLE LIKE 'B'

或

OR

SELECT * FROM EMP WHERE ROLE In ('A','B')

为了找到同时扮演这两个角色的员工，请触发此查询

For finding employees who have both role then fire this query

SELECT EmpId FROM EMP WHERE ROLE LIKE 'A' OR ROLE LIKE 'B' Group by EMPId Having Count(EMPID)>1

祝您编码愉快！
:)

Happy Coding!
:)

选择*从EMP角色如"A"或角色如"B"

或

SELECT * FROM EMP WHERE ROLE像``A''
工会
SELECT * FROM EMP，在角色中像"B"

SELECT * FROM EMP WHERE ROLE LIKE ''A'' OR ROLE LIKE ''B''

OR

SELECT * FROM EMP WHERE ROLE LIKE ''A''
union
SELECT * FROM EMP WHERE ROLE LIKE ''B''

SELECT * FROM EMP GROUP BY EMP_NAME HAVING COUNT(ROLE) >1

这篇关于如何在表中查找具有多个角色的员工的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！