User Profile

Collapse

Profile Sidebar

Collapse
santoshdhote
santoshdhote
Last Activity: Mar 4 '08, 07:09 AM
Joined: Dec 19 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • santoshdhote
    replied to query
    in General
    database :ORACLE 9i
    i'm writing following query,for single record it gives proper result,but whole records it gives mismatch data.


    select contract_number , Product_code, trandate, "prev_statu s", "curr_statu s"
    from
    (
    select contract_number , Product_code, trandate, lag(status_code ) over (order by trandate asc) "prev_statu s",
    status_code "curr_statu s"...
    See more | Go to post

      Leave a comment:

    • santoshdhote
      started a topic query
      in General

      query

      hi to all,
      i have a table with following structure
      contract_number trandate status_date
      1 01-jan-07 a
      2 01-jan-07 a
      1 05-feb-07 b
      3 04-jan-07 a

      now i have to retrive this data in following format

      contract_number trandate previous_status _date...
      See more | Go to post
      No activity results to display
      Show More
      Working...