You can have example.com resolving to 192.198.0.1, 192.168.0.2, 192.168.0.3 It is like looking up google.com where multiple addresses are returned like:
root@mail-www:~# dig -t A google.com
; <<>> DiG 9.18.33-1~deb12u2-Debian <<>> -t A google.com
<snip>
;; ANSWER SECTION:
google.com. 300 IN A 142.250.129.102
google.com. 300 IN A 142.250.129.101
google.com. 300 IN A 142.250.129.113
google.com. 300 IN A 142.250.129.139
google.com. 300 IN A 142.250.129.100
google.com. 300 IN A 142.250.129.138
At the same time you can have example.com, www.example.com, smtp.example.com, mail.example.com etc all resolving to a single IP.