Yes, if your theme shows sale badges. Alpha Sale sets a compare-at price, and your theme shows its own sale badge for every product that has one, in your theme's style. You change the badge look and text in the theme settings. Our support team can also help you customize badges for free, for example to show "-20%" instead of "Sale" or to change the color.
Learn more: Limitations