I've a query with regards to CNAME record, can I have a CNAME as different domain name? Ex. I've a website example.com, can I create a CNAME with example.net? So, irrelevant of what end user types (either example.com or example.net) they should always reach example.com
Two issues collide here. The first is can a CNAME point to a different domain, to which the answer is yes, that is perfectly acceptable.
The second, though, is that in the case of your example, you cannot use a CNAME at all, because you cannot use a CNAME at the apex (aka root) of a domain.
foo.example.net can be a CNAME;
If you're just trying to redirect example.net web site visitors to example.com , that's what you should do. Point example.net A DNS record to example.com's IP address. After that, you have a couple of options;