User Profile

RHNShK

Last Activity: Aug 25 '08, 08:31 AM

Joined: Aug 22 '08

Location:

RHNShK replied to knowing jusT the lasT row

in Oracle

Aug 23 '08, 07:25 PM
didnt work actually,
and seq_no = (select MAX(seq_no) from INVS_TXN_HEAD)

it's still giving all the 5 rows....

See more | Go to post
Leave a comment:

RHNShK started a topic knowing jusT the lasT row

in Oracle

Aug 22 '08, 09:16 PM

knowing jusT the lasT row

Code:

SQL> ED
Wrote file afiedt.buf

  1  select ROUND(avgprice, 10) avgprice, SeQ_no
  2    from (select b.*,
  3                 sum(decode(INVXH_code, 'BUY', invxh_TOTAL_QTY, -invxh_TOTAL_QTY)) OVER (ORDER BY INVXH_date) BALQTY,
  4                 row_number() over (order by invxh_DATE) seq_no
  5            from  INVS_TXN_HEAD b)
  6  -- where INVXH_BROK_code = :INVXH_BROK_code
  7

...

See more | Go to post

No activity results to display

Profile Sidebar

Leave a comment:

knowing jusT the lasT row