Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
X
X
xXRustamXx2020-11-15 23:48:32
PostgreSQL
xXRustamXx, 2020-11-15 23:48:32

How to get users who provide all services?

There is an array of service id: [1, 3]. You need to get users who provide all services. How to do it? Here is the table schema:
5fb19363c339f570731150.png

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Report
R
Rsa97, 2020-11-15
@xXRustamXx

By counting the number of services from this list provided by each user. If there are two of them, then display such a user.

Similar questions
L
Localhost2017-07-21 20:37:19
How to change the carousel? 1Reply
G
GrimJack2017-09-05 13:04:04
Why doesn't carbon parse the timestamp correctly? 2Reply
R
raiboon2015-01-20 15:38:57
How to run queries from a function in parallel in Postgresql? 1Reply
T
trprbr2019-06-12 17:01:13
Auditing changes to a database table with "read-only" permissions? 1Reply
S
Still_Free_Crew2017-01-20 19:36:02
Question for experienced admins. Where to gain enough experience in the shortest possible time? 3Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question