How we can use Aggregate Functions on Encrypted Table Columns?

@Khwaza Bandenawaz Sikkalagar Thank you for reaching out.

This is covered in the limitations section.

https://video2.skills-academy.com/en-us/sql/relational-databases/security/encryption/always-encrypted-database-engine?view=sql-server-ver16#limitations

Not supported unfortunately.

I’d like to have you submit feedback at https://feedbackportal.microsoft.com/feedback/search/?q=azure+sql , so we have this in our backlog for tracking.

Additional information: https://video2.skills-academy.com/en-us/sql/relational-databases/security/encryption/always-encrypted-tutorial-getting-started?view=sql-server-ver16&tabs=ssms

Regards,

Oury