Advertisement
Guest User

Untitled

a guest
Feb 27th, 2015
182
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.26 KB | None | 0 0
  1. | Id | A | B | C |
  2. ------------------
  3. | 1 | 1 | 2 | 3 |
  4.  
  5. | Id | Column | Value |
  6. ------------------------
  7. | 1 | C | 3 |
  8.  
  9. SELECT Id,
  10. (SELECT Max(v)
  11. FROM (VALUES (A), (B), (C)) AS value(v) having Max(v) > 65) as MaxValue
  12. FROM [dbo].[MyTable]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement