Guest User

Untitled

a guest
Aug 17th, 2018
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.20 KB | None | 0 0
  1. Showing class values for different class types in one row
  2. image_id | feature_id | feature_val
  3. _________|____________|____________
  4. 12 | 1 | 41
  5. 12 | 2 | 82
  6. 12 | 3 | 75
  7.  
  8. 74 | 1 | 23
  9. 74 | 2 | 35
  10. 74 | 3 | 72
  11.  
  12. image_id | feature_1_val | feature_2_val | feautre_3_val
  13. _________|_________________|_______________|_______________
  14. 12 | 41 | 82 | 75
  15. 74 | 23 | 35 | 72
  16.  
  17. select image_id
  18. , max(case when feature_id = 1 then feature_val end) as feature_1_val
  19. , max(case when feature_id = 2 then feature_val end) as feature_2_val
  20. from YourTable
  21. group by
  22. image_id
  23.  
  24. SELECT it.image_id,
  25. (SELECT feature_val FROM ImageTable WHERE ImageTable.image_id = it.image_id AND ImageTable.feature_id = 1) AS feature_1_val,
  26. (SELECT feature_val FROM ImageTable WHERE ImageTable.image_id = it.image_id AND ImageTable.feature_id = 2) AS feature_2_val,
  27. (SELECT feature_val FROM ImageTable WHERE ImageTable.image_id = it.image_id AND ImageTable.feature_id = 3) AS feature_3_val
  28. FROM ImageTable AS it
  29. GROUP BY it.image_id
Add Comment
Please, Sign In to add comment