sql server - two row to one row in sql -


i have table below.

customer_number      note       loayltystatus    tier_code 123                  yes 123                  yes        1                  123                                               1             

how combine 1 row 2 row above in select statement?

eg:

customer_number      note       loayltystatus    tier_code     123                  yes    1                1 

select customer_number, max(note),max(loyaltystatus),max(tier_code) yourtable group customer_number 

Comments

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

php - How can I echo out this array? -