Getting the Most Common Field

[admin]

This will return the "field" that is most common in your database.

SELECT TOP 1 field FROM table GROUP BY field ORDER BY COUNT(*)