What I can think of are:
New International Bible Commentary
New Bible Commentary, 21st Century Edition
The Expositor’s Bible Commentary: Abridged (2 Vols.) (not exactly one volume, but I think it is at the same type of those)
The Bible Knowledge Commentary
It seems that New Bible Commentary, 21st Century Edition is the best among the one volume commentary. Do you have any idea about which one is the best?
By the way, I want to ask what is the main difference between a one volume commentary and the footnotes of a study Bible, let say, the ESV Study Bible.
Thanks.