Please help me with a sql query. I have a view with couple of joined tables which displays the results as
Name, Top, Bottom and some other fields. The results looks like
AA 0 100
AA 100 175
AA 150 200
Now i need only one record for the above results as AA 0 200. Min of Top and Max of Bottom for each name.