send query result into mail in sql

How to send a SQL Server Query result in e-mail message?

If we have configured SQL Server Database Mail then we can easily send query result as an attachment in mail body.