By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE t
(UserID int, [User Name] varchar(5), SurveyID int, QuestionID int, ResponseID int, isSkipped int)
;
INSERT INTO t
(UserID, [User Name], SurveyID, QuestionID, ResponseID, isSkipped)
VALUES
(1, 'Test1', 100, 10, 1, 0),
(1, 'Test1', 100, 20, 2, 0),
(2, 'Test2', 101, 10, 3, 0),
(2, 'Test2', 101, 20, 4, 1),
(3, 'Test3', 102, 10, 5, 1),
(3, 'Test3', 102, 20, 6, 1)
;
6 rows affected
select * from t
| UserID | User Name | SurveyID | QuestionID | ResponseID | isSkipped |
|---|---|---|---|---|---|
| 1 | Test1 | 100 | 10 | 1 | 0 |
| 1 | Test1 | 100 | 20 | 2 | 0 |
| 2 | Test2 | 101 | 10 | 3 | 0 |
| 2 | Test2 | 101 | 20 | 4 | 1 |
| 3 | Test3 | 102 | 10 | 5 | 1 |
| 3 | Test3 | 102 | 20 | 6 | 1 |
select UserID
,[User Name]
,SurveyID
,max(isSkipped) as Complete
from t
group by UserID, [User Name], SurveyID
| UserID | User Name | SurveyID | Complete |
|---|---|---|---|
| 1 | Test1 | 100 | 0 |
| 2 | Test2 | 101 | 1 |
| 3 | Test3 | 102 | 1 |