i have one doubt

2006-01-28 Thread Veerabhadrarao Narra
i have to write one query DivisionUnitsYear a 200 2004 a 300 2005 b 500 2004 b 800 2005 b 900 2006 c

Re: i have one doubt

2006-01-28 Thread Veerabhadrarao Narra
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]

Re: i have one doubt

2006-01-28 Thread Gleb Paharenko
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 one doubt

2006-01-27 Thread Veerabhadrarao Narra
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