I have a table structure as follows,
partno , Qty and price
the data i have is
xyz 100 1000
abc 200 900
lmn 300 500
xyz 500 200
so as the quantity increases the price decreases.
i want a output like the max is the next value in the min col.
min max price
100 200 1000
200 300 900
300 500 500
500 200
how do i write a query to get this output from the above table structure ....
Can anyone help me with this???
partno , Qty and price
the data i have is
xyz 100 1000
abc 200 900
lmn 300 500
xyz 500 200
so as the quantity increases the price decreases.
i want a output like the max is the next value in the min col.
min max price
100 200 1000
200 300 900
300 500 500
500 200
how do i write a query to get this output from the above table structure ....
Can anyone help me with this???