Hi Guys
I have a table that contains codes for commodities.Som e of the codes in this table have changed and some of them have not.So now i want to design a solution that enable me to map the new codes in a different mapping table to the old ones in the other table.I also want to retain the old codes because most of the archived data used the old codes.
Where there is no new code, the current code is being retained.How...
magikminox
Last Activity: Apr 18 '08, 12:17 PM
Joined: Mar 26 '08
Location:
-
Mapping values in one table column to another table column
-
magikminox started a topic Selecting rows representing highest value for columname1 for each columname2in SQL ServerSelecting rows representing highest value for columname1 for each columname2
Hi Folks
I have a table in this format
TradeID ActionID
58096 3664
58096 3665
58097 3685
58097 3687
…..
I want to select all the rows but only the rows that represent the highest ActionIDs for each TradeID
For some reason this query is not giving me the correct results
SELECT cct.TradeID,cct .ActionID
...
No activity results to display
Leave a comment: