requesting certain row from query

  • Thread starter Thread starter Kayak
  • Start date Start date
K

Kayak

hi all

this question is same as i asked before but i din get
exact answer.now i'll simplify my question to get u better
idea of what i requested of.i have table Transaction as
below
TransID ProductID ResaleCost PriceCost Quantity
1 4 $100 $91 9
2 5 $150 $145 10
3 1 $50 $44 2
4 4 $450 $430 46
5 2 $615 $600 30
6 1 $51 $44 2
7 6 $440 $432 7
8 4 $255 $245 25

let say i created query A whereby all data are same as
table BUT priceCost is in descending order.so it would be
like;
TransID ProductID ResaleCost PriceCost Quantity
5 2 $615 $600 30
7 6 $440 $432 7
4 4 $450 $430 46
8 4 $255 $245 25
2 5 $150 $145 10
1 4 $100 $91 9
6 1 $51 $44 2
3 1 $50 $44 2

now i want to select its row 50% of total transaction(but
base on quary A table)where 50%*8=row#4. so in this case
it would be;
TransID Product ID ResaleCost PriceCost Quantity
8 4 $255 $425 25

how can i do that?


cheers,
kayak
NB: its not using TOP VALUE whereby its list out all data
from selected x.
 
Back
Top