FUNCTION || INBUILT FUNCTION || SINGLE ROW FUNCTION || MULTI ROW FUNCTION ||SQL
This video is about inbuilt function in SQL.
SINGLE ROW FUNCTION || MULTI ROW FUNCTION ||SQL.
Questions On Inbuilt function in SQL
1.WAQTD maximum salary, minimum commission present in the table.
2. WAQTD total sal needed to pay for all the emps who are working as manager.
3. WAQTD avg comm given to emps who’re working in deptno 20 or 30.
4. WAQTD no. of emps working in dept no. 20
5. WAQTD MAX, MIN, SUM,AVG sal given to all the emps whose name does not start with “M”.
6. WAQTD no. of emps hired in the month of dec or jan.
7. WAQTD total sal needed to pay for all the emps whose job includes ‘%’ as 2nd character.
8. WAQTD no. of emps getting comm in dept 20 or 30 if they are salesman.
9. WAQTD ename of emps who are not working as PRESIDENT.
10. WAQTD recently / last hired emps HIREDATE.
11. WAQTD first hired emps hiredate.
12. WAQTD no. of deptno. Present in your emp table.
13. WAQTD no of job present in your emp table.
14. WAQTD no. of employees whose name includes ‘_’ as a third character or second last charater.
15. WAQTD no. of employees hire during the year 82 or 87 or 88.
16. WAQTD details of employees who are getting comm without using null.
17. WAQTD max sal present in dept no. 20.
18. WAQTD max sal in dept 30.
19. WAQTD max sal present in each dept.
On this page of the site you can watch the video online FUNCTION || INBUILT FUNCTION || SINGLE ROW FUNCTION || MULTI ROW FUNCTION ||SQL with a duration of hours minute second in good quality, which was uploaded by the user Tiny Owl 06 March 2022, share the link with friends and acquaintances, this video has already been watched 168 times on youtube and it was liked by 3 viewers. Enjoy your viewing!
