uttarkar
uttarkar
Untitled
25 posts
Don't wanna be here? Send us removal request.
uttarkar · 2 years ago
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
Tumblr media
0 notes
uttarkar · 2 years ago
Text
DISPLAY ALL THE RECORDS EMP TABLE WHERE JOB IS 'MANAGER' OR 'ANALYST'.
Tumblr media Tumblr media
0 notes
uttarkar · 2 years ago
Text
DISPLAY DISTINCT JOBS IN EMP TABLE.
Tumblr media
0 notes
uttarkar · 2 years ago
Text
DISPLAY DEPTNO, LOWEST SALARY FROM EACH DEPTNO FROM EMP TABLE
Tumblr media
0 notes
uttarkar · 2 years ago
Text
DISPLAY HIGHEST SALARY FROM EACH DEPTNO FROM EMP TABLE WITH DEPTNO IN ASCENDING ORDER.
Tumblr media
0 notes
uttarkar · 2 years ago
Text
DISPLAY LOWEST SALARY FROM EMP TABLE.
Tumblr media
0 notes
uttarkar · 2 years ago
Text
DISPLAY HIGHEST SAL FROM EMP TABLE.
Tumblr media
0 notes
uttarkar · 2 years ago
Text
DISPLAY ALL THE RECORDS IN EMP TABLE FOR THOSE WERE NOT JOINED IN YEAR 1981.
Tumblr media
OR
Tumblr media
0 notes
uttarkar · 2 years ago
Text
DISPLAY ALL THE EMPLOYEE RECORDS THOSE WHO JOINED BETWEEN YEAR 1981 AND 1982.
Tumblr media
OR
Tumblr media
0 notes
uttarkar · 2 years ago
Text
DISPLAY ALL EMPLOYEE RECORDS THOSE WHO JOINED IN YEAR 1981.
Tumblr media
OR
Tumblr media
0 notes
uttarkar · 2 years ago
Text
Tumblr media
10 posts!
0 notes
uttarkar · 2 years ago
Text
DISPALY ALL THE RECORDS IN EMP TABLE WHERE ENAME FIRST CHARACTER COULD BE ANYTHING, BUT SECOND CHARACTER SHOULD BE L.
Tumblr media
0 notes
uttarkar · 2 years ago
Text
DISPLAY ALL THE RECORDS IN EMP TABLE WHERE ENAME ENDS IN S.
Tumblr media
0 notes
uttarkar · 2 years ago
Text
DISPALY ALL THE RECORDS IN EMP TABLE WHERE ENAME STARTS WITH A AND ENDS IN S.
Tumblr media
0 notes
uttarkar · 2 years ago
Text
DISPLAY ALL THE RECORDS IN EMP WHERE ENAME STARTS WITH A.
Tumblr media
0 notes
uttarkar · 2 years ago
Text
DISPLAY ALL THE RECORDS IN EMP TABLE WHERE ENAME LENGTH = 5.
Tumblr media
0 notes
uttarkar · 2 years ago
Text
DISPLAY ALL THE RECORDS IN EMP TABLE WHERE COMM IS NOT NULL.
Tumblr media
0 notes