Does it simply depend on if we are in $\mathbb{R}$ or $\mathbb{Q}$, and whether the supremum exists in this set? like a set of all $a^2 < 2$ will be upper-bounded in $\mathbb{Q}$, but won't have a supremum, and in $\mathbb{R}$ it will be both upper-bounded and have a supremum?
Does it always work like that and is this the only difference?