help with conversion

am using the following two queries in my program

SELECT COUNT (ballNo)/6 AS 'over' from CRICINFOMATCHSTATISTICTABLE where bowlerId='10'

SELECT COUNT(ballNo)%6 AS 'over' from CRICINFOMATCHSTATISTICTABLE where bowlerId='10'

from first query i get the value in 'over' column as '1' and in second query i get the value in 'over' column as '3'

how can i concatenate both the values so that i can get the result as 1.3

i want to convert the second value to decimal,ie .3

[517 byte] By [@chillzonea] at [2007-11-27 4:51:11]

# 1

Cast both results to doubles, divide the second value by 10, and then add the two results together.

If you don't know how many digits long your second result will be, here's two ideas:

The first, divide it by 10 to the number of digits.

The second:

String s = result1 + "." + result2;

Double d = Double.parseDouble(s);

ktm5124a at 2007-7-12 10:04:50 >

Java Essentials New Topic