If you place the links yourself, then Google is highly unlikely to give much weight to them at all.
If other reputable websites in the same - or related - niche choose to link to yours, then Google will generally give those links more weight than links from unrelated pages. (But Google’s algorithms are highly complex, and other factors may affect how it views the links.)