Oracle Built in Functions part 2 - SQL Functions Tutorial with examples- SQL Single Row Functions

Oracle built in functions, to_char, to_date, sqrt, power, sign, round functions of SQL. Full courses : SQL - https://bit.ly/38c91ih | Python - https://bit.ly/3ihca4L | MongoDB - https://bit.ly/38bRJ4K | PL/SQL - https://bit.ly/2Zl4OVw #SQLGroupBy #GroupFunctions #Crazy4DB #MunshiSir #LearnSQL #BasicSQL Problem to solve : Please solve the query of listing rows of employees who are getting less salary than the average salary of their own department by using in-line view. Interview Question : How the avg function is used to find the average over all the rows in the group if the referenced column may contain NULL values. My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/