I am currently using 2 Queries to get to the value i am looking for and am wondering if i could do this in one.
My table has 2 Col's of intrest lets called them ColA and ColB
and so on, i have the value of ColA lets say 10002 and i need to find the largest value
in my table for ColA where ColB = the same as for the row of 10002 which is 51 in the
Right now i query for Colb based on 10002 and then in a second query i select max of
colA where colB = the value i got infirst query.
Any ideas to do this in one query would be great