January 30, 2009 at 8:15 am
Hey guys, this is probably a novice question for most of you out there. I've been tasked with creating an index for a map book we use. I have the raw data to create this index. I can even see what needs to be done to get it, but my sql skills are very basic. Here's a sample of my data and the required output I need.
Thanks for any help
innerGridgridMaindirectionstrtNamestrtTypelfAddltAddrfAddrtAddID
A - 2 8 S 10TH ST 0 618 613 619 23778
A - 2 8 S 10TH ST 604 606 603 611 23781
A - 2 8 S 10TH ST 0 0 111 117 23790
A - 2 8 S 10TH ST 0 0 0 0 23791
What I need is to combine like rows based off the 1st 5 fields matching, from there I then need to to determine my min and max value based off of the lfAdd, ltAdd, rfAdd, and rtAdd fields.
My desired output would look like this
innerGridgridMaindirectionstrtNamestrtType Minimum Maximum
A - 2 8 S 10TH ST 111 619
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply