I want to get a map of rate_code and ID instead of Id and Rate object directly from SOQL query.
If i run following query then i will have to iterate over rateMap map to create
Map<String rate_code , String ID>. Is there any other efficient way to get this kind of result directly using soql OR by doing minimal manipulations in apex code ?
Map<String, Rate> rateMap = [select id, rate_code from Rate];