troubleshooting Question

Strip third+ level domains from a list

Avatar of raterus
raterusFlag for United States of America asked on
Microsoft SQL Server
7 Comments1 Solution385 ViewsLast Modified:
Hi,  I'm trying to develop a query to consolidate and get just the 1st and 2nd level domains in a list.

e.g. this query will take

blah.somedomain.com
fourth.third.somedomain.com
whatever.somedomain.com
test.anotherdomain.com
fourth.test.anotherdomain.com

and simply return
somedomain.com
anotherdomain.com

Can I do this from a sql query, if so how?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros