How to send SQL query result over mail

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.