Reply to thread

Message: <blockquote data-quote="deepwater" data-source="post: 22902574" data-attributes="member: 545097">Mulinma ube table structure eka oita wada improve karanta puluwan. Oya currency code table eka galawala eka country table ekema column ekakata dammaki. Performance wise meka maara speed.Ube prashneta uththare, procedure ekak one na simple query ekak athi.Select c.countryid , d.code, e.rateFrom country c, currencycode d, exrate eWhere c.countryid = d.countryid and c.countryid = e.countryidGroup by c.countryid, e.idHaving e.id = max(e.id)Order by e.idMama meka test kare na, poddak test karala balapan.Ubata wenta one country wise group unata passe max id eka thiyana rate row eka each group eke. Having eka dala thiyenne ekata. Poddak check karala, one nam change karala ganin. Habai basic structure eka query eke me wage thama</blockquote>

Top Bottom