Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --ZADANIE 2
- SELECT *
- FROM EMPLOYEE
- --WHERE FIRSTNME BETWEEN 'C' AND 'S'
- WHERE SUBSTR(LCASE(FIRSTNME), 1, 1) BETWEEN 'c' AND 's'
- AND SUBSTR(LCASE(FIRSTNME), 3, 1) NOT LIKE 'l'
- -- ZADANIE 6
- SELECT CURRENT TIME, CURRENT DATE
- FROM SYSIBM.SYSDUMMY1
- -- ZADANIE 7
- SELECT FIRSTNME, LASTNAME, BIRTHDATE
- FROM EMPLOYEE
- WHERE BIRTHDATE BETWEEN (SELECT CURRENT DATE - 50 YEARS
- FROM SYSIBM.SYSDUMMY1) AND (SELECT CURRENT DATE - 30 YEARS
- FROM SYSIBM.SYSDUMMY1)
- db2set DB@_COMPATIBILITY_VECTOR=ORA
- db2set DB2_DEFERRED_PREPARE_SEMANTICS=YES
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement