Can anybody help me with this simple MySql code
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
View Answers
Ads
Related Tutorials/Questions & Answers:
Can anybody help me with this simple MySql code
Can anybody help me with this
simple MySql code select c.countryid... 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
Advertisements
Can anybody tell me how to resolve this issue?
Can anybody tell
me how to resolve this issue? java.lang.Exception: Exception :
java.lang.Exception: Generic Errors = java.util.MissingResourceException: Can't find bundle for base name Connection, locale en_US
Can someone help me with this?
Can someone
help me with this? I have this project and i dont know how to do it.
Can someone
help me? please?
Write a java class named "PAMA..., Multiply, Divide)
Help me please! Thanks in advance!
import
Can you help me with applet?
Can you
help me with applet? I'm very new to applet, and i'm weak in graphic design part. How
can i add the graphic in my test project?
Can you
help me with this:
import java.io.*;
import java.util.*;
import javax.swing.
Can any one please help me in this ,,,,,,, need java code for this ,,,,please anyone
Can any one please
help me in this ,,,,,,, need java
code for this ,,,,please anyone The Airport Valet Parking Company (AVP) is a company which provides a convenient medium cost parking solution to users of a local airport. Key
PLZ HELP ME. i need php code.
PLZ
HELP ME. i need php
code. I want php
code for bellow OUTPUT.
output is just example but it must be letters only.
abc
bcd
efg
jku
rgt
azs
hje
qqc
wws
adt
Help me to write this simple java frame program
Help me to write this
simple java frame program I want to write a Java program for....
To create a frame with 4 text fields;name,street,city and pin;with suitable labels.
Also add a button "OK". After enter values
Please help me to modify my java code from php code
Please
help me to modify my java
code from php code i want to covert...) ... but this is not giving
me the exact result as the above PHP
code is giving. So please
help me to convert it into Java.
if (request.getParameter("orders") != null
Please help me to modify my java code from php code
];
}
}
I tried like this (see below JSP
code) ... but this is not giving
me the exact result as the above PHP
code is giving. So please
help me to convert...Modify Java
code from PHP Code i want to covert this php
code int
help me
help me please send
me the java
code to count the number of similar words in given string and replace that word with new one
help me
help me i have done as u directed but nothing happens gud to
me..... . i am using netbeans is that matter at all
help me and take
me out from trouble
where to store jfree api to use it for j2ee based project
help me
help me HI. Please
help me for doing project.
i want to send control from one jsp page to 2 jsp pages... is it possible? if possible how to do
help me
help me MY GLASSFISH SERVER NOT START PROPERLY
help me
warning shows
DPL5404:Specification-Version for the optional package [ GNUJAXP ] in the jarfile [ C:\Program Files\Java\jdk1.7.0_02\jre\lib\ext\gnujaxp.jar
help me..
help me..
what are the component needed by grid computing, cloud computing and ubiquitous computing?
discuss about the security of above computing.
difference between that 3 computing
help me...
help me... Write a program that inputs four words and them displays all possible permutations of the words. So,
for example, if the words mad, dog, bites and man are entered, then the following are output :
man bites mad dog
help me..
help me.. Write a program that inputs four words and them displays all possible permutations of the words. So,
for example, if the words mad, dog, bites and man are entered, then the following are output :
man bites mad dog
mad
Help me
Help me hello!!!!.
i have a Excel file which includes 4 columns and somewhat 8500 rows.these rows i have printed in SQL thru Excel file
and i have 1
MYSql database which includes all those 4 fields i have defined in excel file
help me
button, and nationality I'm using dropdown list. Please
help me. your kindness...
help me Hi I'm loges. I'm doing my final year project now, I have some problem in my project and i need some
help on it. NowI'm doing a site