Pivot to return max data with multiple users

Transact-SQL
1

Pivot the following to only show max data

Id,date,user,num1,num2,num3
2,2017-01-09 00.00:00:00,John,null,5,null
2,1980-05-23 00:00:00:00,Jane,6,4,null

Result
Id,date,user
2,2017-01-09 00.00:00:00:00,John,null5,null

2

Please, at least put a little effort on your questions to provide proper ddl and dml?

1 Like
3

how about

select max(col1),max(col2),max(col3)