SQL problem

[ilya123]

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

[debasisdas]

Kindly post the query that you have tried to solve the problem to get more help from our inhouse experts.

[ilya123]

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

[debasisdas]

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

Kindly post the query that you have tried to solve the problem to get more help from our inhouse experts.