When using the Select by Attributes tool it creates a new layer. I don't need a new layer to be created and end up removing the created layer almost immediately. Is there a way to stop the tool from creating a new layer?
I'm not encountering this issue but it may help others offer some assistance if you provide the version of Pro you're using and what sort of feature is being selected (i.e. feature class, hosted feature layer, all data regardless of source, etc.), and lastly, if you're using the geoprocessing tool or simply using the "select by attributes" tool on the map ribbon.
Whenever I see strange behavior like this, I recommend doing a soft factory reset. You can follow the steps listed here. Once the reset is complete, open your *.aprx and try the Select by Attributes workflow again.
I am using version 3.2.2. The feature being selected is a feature class. Also I am using the Select by attributes on the map ribbon.