如何在查询中选择NOT MAX（）的记录

I need to be able to view a column in a table that has duplicates in it. Currently I can use MIN() and MAX() to and see results. However it's not being reliable (records could appear more than twice). How can I see the max records in one column while viewing all the records that are NOT MAX in another?I need to be able to view a column in a table t