
select c.countryid, r.bp, r.sp, c.country, t.timee
from rate as r, countryloc as c, todaysrate as t
where r.countryid=t.countryid and t.countryid=c.country
this is waht i gt whn i run that:
countryid bp sp country time 2 43 53 ind 2013-03-17 17:25:15 2 34 23 ind 2013-03-16 18:26:20 3 34 37 ken 2013-03-17 18:26:32 1 54 61 jpy 2013-03-17 18:26:40 5 23 33 aus 2013-03-17 18:26:42 6 32 35 cad 2013-03-16 18:26:31
can any one help me with the query because i want to select al of them but it should select for me only 1 duplicate countryid and the last time one. meaning the one with the greatest time. this is what my a query should display me:
countryid bp sp country time 2 43 53 ind 2013-03-17 17:25:15
3 34 37 ken 2013-03-17 18:26:32 1 54 61 jpy 2013-03-17 18:26:40 5 23 33 aus 2013-03-17 18:26:42 6 32 35 cad 2013-03-16 18:26:31
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.