row operation in same table and same coloumns

Posted by Raj on Stack Overflow See other posts from Stack Overflow or by Raj
Published on 2010-05-07T12:14:15Z Indexed on 2010/05/07 12:18 UTC
Read the original article Hit count: 281

Filed under:

row

Hi! i have a little problem to discuss i hope it will easy for you. suppose i have table A with 2 columns as

item          price
milk           25
milk           50
milk           100
Butter         25
Butter         100
Butter         200

now i want to display a table B derived from table A as

item          price growth rate
milk           0
milk           100
milk           100
Butter        100
Butter         200
Butter         100

formula for growth rate for row1 is

((row[1]-row[0])/row[0])*100
eg for 1st row ((50-25)/25)*100

can you suggest a SQl Query for it

Related posts about row

php foreach question

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following code $oldID=-1; $column=0; foreach($pv->rawData as $data){ if ($oldID!= $data->relativeTypeID){ $oldID= $data->relativeTypeID; $column++; $row=1; } echo "Row: ".$row.": Column: ".$column.": ID".$data->relativeTypeID."<br>";… >>> More
sql pulling a row for next or previous row of a current row

as seen on Stack Overflow - Search for 'Stack Overflow'
id | photo title | created_date XEi43 | my family | 2009 08 04 dDls | friends group | 2009 08 05 32kJ | beautiful place | 2009 08 06 EOIk | working late | 2009 08 07 Say I have the id 32kJ. How would I get the new or previous row? >>> More
how to display the below xml in the flex datagrid

as seen on Stack Overflow - Search for 'Stack Overflow'
<rows> - <row rowno="1"> - <row-value> <colno>1</colno> <value>1</value> </row-value> - <row-value> <colno>2</colno> <value>sel</value> </row-value> - <row-value> <colno>3</colno> <value>select… >>> More
Mysqli results memory usage

as seen on Stack Overflow - Search for 'Stack Overflow'
Why is the memory consumption in this query continuing to rise as the internal pointer progresses through loop? How to make this more efficient and lean? $link = mysqli_connect(...); $result = mysqli_query($link,$query); // 403,268 rows in result set while ($row = mysqli_fetch_row($result)) { … >>> More
Flex / Flash builder : no returning data using database

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, i'm following some flex tutorials everything's working as wanted expected for one thing : When i use my function getServerByBrand($brand) there is no returned data into my datagrid and i don't know why because it uses the same schema as getAllserver() which is working . I don't know whether… >>> More

Developer IT

row operation in same table and same coloumns - Developer IT

row operation in same table and same coloumns

row

Related posts about row

php foreach question

sql pulling a row for next or previous row of a current row

how to display the below xml in the flex datagrid

Mysqli results memory usage

Flex / Flash builder : no returning data using database

Categories cloud