Display different rows of a record in a single row having all the column values

Question

I am using SQL Server 2008 ,

I have an Orders table where it lists two records with different column values.

For ex:

OrderNumber - SalesNumber - Success/Fail

91010 --- Success

91010 4786 ---

I need to display this as a single row.

OrderNumber - SalesNumber - Success/Fail

91010 - 4786 - Success

Is this possible using SQL Query. How to do that?. Please Suggest

Answer 1

Try this:

select ordernumber, max(salesnumber), max(successfail)
from yourtable
group by ordernumber