User Profile

Collapse

Profile Sidebar

Collapse
ilya123
ilya123
Last Activity: Sep 15 '07, 06:26 PM
Joined: Sep 14 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • ilya123
    replied to SQL problem
    in Oracle
    Just clarify. Running select * from table_name I'm getting order_id = 1,step_id = A, order_id = 1, step_id = B, order_id = 1, step_id = C and so on. But I need just any 2 rows for each order_id
    See more | Go to post

      Leave a comment:

    • ilya123
      started a topic SQL problem
      in Oracle

      SQL problem

      Hi, I need some SQL help.
      Simplify a problem I have 2 colums: order_id and step_id. Every order_id may have any number of step_id (step_id is random varchar(19) with absolutly random number-letter). I need pick up any 2 records for every order_id.
      Thank you in advance
      See more | Go to post
      No activity results to display
      Show More
      Working...