The output will be saved as "Count_<column name>_<row number>" in your case, Count_COUNT_1 should have the output.

You can use a Javascript to read the output and save it in a variable and use it.

If you execute Select * from <Tablename> then you may get more than 1 column and 1 row and to get a specific cell you can specify the column name and row number to get values. Column information would be "Column Name" and row information would be the "row number". In your case, the column name would be "COUNT" and there will be only 1 row so you need to specify that specific value.

Sample code:

var myVar = context.variableManager.getValue("Count_COUNT_1");

context.variableManager.setValue("<Neoload_VariableName>",myVar);

Share the output from the SQL Custom Action step. Are you able to see the output (count) there?

The variableName says 'Total' inside the Custom Action. Change the javascript to Total_COUNT_1. Please note JavaScript is case sensitive.

Can you try to change the query to select * from table to see if you see any output in the custom action?

In the screenshot, I see it being blank.

Please attach screenshots of the custom action and the output of the custom action.

When you execute the following query in SQL server you are able to get output?
SELECT * FROM [employee].[dbo].[tblProductSales]