Cognizant SQL Interview Question | Extract the Domain from the Email Column in Employee Table

[@rohitconnect]

RIGHT(email,(len(email)-locate('@',domain))) should this work as well? i dont have Sever to test

[@datasciencecorner]

Will check and let you know

[@monasanthosh9208]

Select *,concat(replace(Name," ","."),"@",domins) as email from domin;

[@datasciencecorner]

Great! Keep practicing :)