Are you asking how to do this using SQL? This is a Java forum, not a SQL forum.

I can move this thread to the "other languages" forum and hope somebody knows more about SQL if you want, but I'd...