Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT INITCAP(DEPT) "Dept_Name",
- LENGTH(DEPT) "Length"
- FROM TEMP_ITEM
- WHERE DEPT LIKE 'P%'
- OR DEPT LIKE 'Q%'
- OR DEPT LIKE 'R%'
- OR DEPT LIKE 'S%'
- ORDER BY DEPT DESC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement