SQL Query to retrieve all Junior Girls
SQL query to retrieve all junior girls
SELECT *
FROM Member m
WHERE m.MemberType = 'Junior'
AND m.Gender = 'F';
Conclusion
The above query useful to retrieve all junior girls.
SQL Query to display the EMPNO, ENAME, JOB, HIREDATE, EXP of all Managers
SELECT EMPNO , ENAME , JOB , HIREDATE , MONTHS_BETWEEN ( SYSDATE , HIREDATE ) EXP FROM EMP WHERE EMPNO IN ( SELECT MGR FROM EMP );
Comments
Post a Comment