How to use Count correctly

Asked

Viewed 50 times

0

I used this query to find the Js that do not relate:

SELECT *FROM D_WRKDB.TB_RDMP_CTRLM_JOB CTJ
LEFT JOIN D_WRKDB.TB_RDMP_CTRLMJOB_HAS_WORKFLOW CTW
    ON CTW.ID_CTRLM_JOB = CTJ.ID_CTRLM_JOB
    WHERE CTW.ID_CTRLM_JOB IS NULL

Now I need to use a Count in the column MEMNAME that’s on the table TB_RDMP_CTRLM_JOB.

But I’m not getting it.

Anyone can help?

sql

  • And what was the SQL you tried to do? What was the result?

  • Do you want to count how many occurrences there are for each MEMNAME value? Something like,,, COUNT(*) ... GROUP BY MEMNAME?

  • What problem did you find? gave some error?

  • I managed to solve using GROUP BY ! THANKS FOR THE PERSONAL HELP!

No answers

Browser other questions tagged sql

You are not signed in. Login or sign up in order to post.