Don't wanna be here? Send us removal request.
Text
DISPLAY THE EMPLOYEE'S NAME WITH FIRST LETTER CAPITALIZED AND ALL OTHER LETTERS IN LOWERCASE FOR ALL EMPLOYEES WHOSE NAME STARTS WITH J, A, OR M
0 notes
Text
DISPLAY ALL THE RECORDS EMP TABLE WHERE JOB IS 'MANAGER' OR 'ANALYST'.
0 notes
Text
DISPLAY DEPTNO, LOWEST SALARY FROM EACH DEPTNO FROM EMP TABLE
0 notes
Text
DISPLAY HIGHEST SALARY FROM EACH DEPTNO FROM EMP TABLE WITH DEPTNO IN ASCENDING ORDER.
0 notes
Text
DISPLAY ALL THE RECORDS IN EMP TABLE FOR THOSE WERE NOT JOINED IN YEAR 1981.
OR
0 notes
Text
DISPLAY ALL THE EMPLOYEE RECORDS THOSE WHO JOINED BETWEEN YEAR 1981 AND 1982.
OR
0 notes
Text
DISPLAY ALL EMPLOYEE RECORDS THOSE WHO JOINED IN YEAR 1981.
OR
0 notes
Text
DISPALY ALL THE RECORDS IN EMP TABLE WHERE ENAME FIRST CHARACTER COULD BE ANYTHING, BUT SECOND CHARACTER SHOULD BE L.
0 notes
Text
DISPLAY ALL THE RECORDS IN EMP TABLE WHERE ENAME ENDS IN S.
0 notes
Text
DISPALY ALL THE RECORDS IN EMP TABLE WHERE ENAME STARTS WITH A AND ENDS IN S.
0 notes
Text
DISPLAY ALL THE RECORDS IN EMP WHERE ENAME STARTS WITH A.
0 notes
Text
DISPLAY ALL THE RECORDS IN EMP TABLE WHERE ENAME LENGTH = 5.
0 notes