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
Related Tutorials/Questions & Answers:
Can anybody help me with this simple MySql codeCan 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.
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
Can any one please help me in this ,,,,,,, need java code for this ,,,,please anyoneCan 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
please help me to give code - Java Beginnersplease
help me to give code Write a function with a signature cheerlead(word) that prints a typical cheer as follows. The word robot:
Gimme an R
Gimme an O
Gimme a B
Gimme an O
Gimme a T
What did you give
me?
ROBOT
please help me to give code - Java Beginnersplease
help me to give code Write a function, sliding(word, num)that behaves as follows. It should print out each slice of the original word having length num, aligned vertically as shown below. A call to sliding(examples, 4
please help me to give code - Java Beginnersplease
help me to give code Write a program that prints an n-level stair case made of text. The user should choose the text character and the number of stairs in the stair case
*
**
***
****
Hi friend
please help me to give code - Java Beginnersplease
help me to give code Write a program that uses loops to generate an n x n times table. The program should get n from the user. As a model here is a 4 x4 version:
| 1 2 3 4
Please help me fix this code - MobileApplicationsPlease
help me fix this code
Please
help me in this area of
code... in the background of the forms in this
code
i want to sum all expenses amount...);
//*********************************************This
code section is for List All Trip Expenses Screen
please help me to give code - Java Beginnersplease
help me to give code Write a program that reads a file named famous.txt and prints out the line with the longest length. In the case of a tie, you may print out only one of them. For example in the file:
Alan Turing
Please help me to modify my java code from php codePlease
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
Any one can help me? - Java BeginnersAny one
can help me?
CAN any of u
help me to do this java codes for the interface given below?
thanku
the user will be given jumbled words.... If the player is able to arrange all the words without any mistake, he/she
can get
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 mehelp 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 mehelp me hi sir pls tell
me
how to use ajax form validatin from very
simple way with two ot three text field pls
help me use ajax in php
my email id is:-
[email protected]
pls sir give
me some vasic information i know
help mehelp 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 mehelp 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 mehelp 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 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
Help meHelp 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 help me... class.Several lines of customer should be displayed.
you
can add a new customer
Help MeHelp Me What is the source
code for Sample example for Mortgage Calculator in J2ME language for developing Symbian