i have to write one query
DivisionUnitsYear
a 200 2004
a 300 2005
b 500 2004
b 800 2005
b 900 2006
c
Hi Gleb Paharenko,
ThanQ for assistance
--
veerabhadrarao narra,
+91-988-556-5556
I-ONE TECH LABS Pvt Ltd.
HYDERABAD, INDIA
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello.
set @s:=0;
select Division, Units, Year from (select v1.Division, [EMAIL PROTECTED] as
Units, v1.Year, @s:=v1.Units from veer v1) as v2;
Veerabhadrarao Narra wrote:
> i have to write one query
>
> DivisionUnitsYear
> ameerpet 200 2004
>
i have to write one query
DivisionUnitsYear
ameerpet 200 2004
ameerpet 300 2005
ameerpet 500 2006
>From these values i want to retreive as like this
DivisionUnitsYear