MYSQL How do I Select all emails from a table but limit number of emails with the same domain

MYSQL How do I Select all emails from a table but limit number of emails
with the same domain

References

Reference NO 1

http://stackoverflow.com/questions/15187839/mysql-how-do-i-select-all-emails-from-a-table-but-limit-number-of-emails-with-th

Reference NO 2

http://stackoverflow.com/questions/11317427/limiting-multiple-results-from-a-mysql-query

Reference NO 3

http://docs.cpanel.net/twiki/bin/view/AllDocumentation/WHMDocs/TweakSettings

Reference NO 4

http://dev.mysql.com/doc/en/grant.html

Reference NO 5

https://workaround.org/ispmail/lenny/postfix-database-mappings

Reference NO 6

https://help.ubuntu.com/community/PostfixCompleteVirtualMailSystemHowto

Reference NO 7

http://coursesweb.net/php-mysql/php-mysql-where-like

Reference NO 8

https://library.linode.com/email/postfix/postfix2.9.6-dovecot2.0.19-mysql