Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT a.myVal, b.myVal
- FROM MyTable a, MyTable b
- WHERE
- a.otherVal = 100 AND
- b.otherVal = 200 AND
- a.id = b.id
- select a.myVal,
- b.myVal
- from MyTable a
- join MyTable b on b.id = a.id
- where a.OtherVal = 100
- and b.Otherval = 200
- SELECT
- id,
- MAX(CASE OtherVal WHEN 100 THEN MyVal END) AS MyVal1,
- MAX(CASE OtherVal WHEN 200 THEN MyVal END) AS MyVal2
- FROM MyTable
- WHERE OtherVal IN (100, 200)
- GROUP BY
- id
- ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement