SELECT id FROM @itab AS tab
WHERE animal = 'bear' AND count = 5
INTO TABLE @it.
SELECT id FROM @itab AS tab
WHERE animal = 'kangaroo' OR count = 4
INTO TABLE @it.
SELECT id FROM @itab AS tab
WHERE ( animal = 'bear' AND count = 5 )
AND ( animal = 'lion' AND count = 20 )
INTO TABLE @it.
SELECT id FROM @itab AS tab
WHERE ( animal = 'bear' AND count = 5 )
OR ( animal = 'lion' AND count = 20 )
INTO TABLE @it.
SELECT id FROM @itab AS tab
WHERE count > 10
OR NOT ( animal = 'kangaroo' AND count = 8 )
INTO TABLE @it.
Serkan AKKAVAK
Computer Engineer BSc
Head of SAP & Software Department
Contact : serkurumsal@yandex.com
0 Comments