Help getting record count... RRS feed

  • Question

  • User-507786106 posted

    Please see my codes I need to get the record count, but have not formulated the code correctly, please help with your expertise to get a record count.

    Goal: Return Record Count

    SELECT  Acolumn1, Bcolumn2, Ccolumn3

    FROM [Test1]...TableA

    WHERE Acolumn1 NOT IN (SELECT Acolumn1 FROM MyTable2 )

    Instead of getting rows back how do I get a record count from the above query?

    Thank you

    Wednesday, February 27, 2019 5:36 PM