0

Should I use Select or Count when an employee (CI_NUM) creates a record in multiple facilities (FAC_NUM)?

edit

• employee

asked 2022-07-30 11:00:00 +0000

plato
56 ●5 ●5

edit retag flag offensive close merge delete

add a comment

1

answered 2022-03-20 21:00:00 +0000

woof
21 ●1 ●1

If you want to know how many records an employee has created in all facilities, you should use COUNT. If you want to know the list of facilities where the employee has created records, you should use SELECT.

edit flag offensive delete link more

add a comment

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss