AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Avg will not update9/5/2023 ![]() For example, the following statement gets the department that has the average salary less than 5000: SQL AVG with a subquery To filter group, you use the AVG function in the HAVING clause. ![]() Try It SQL AVG with HAVING clause example To sort the result set that includes the AVG results, you use the AVG function in the ORDER BY clause as follows: SELECT Try It SQL AVG with ORDER BY clause example INNER JOIN departments d ON d.department_id = e.department_idÄ®.department_id Code language: SQL (Structured Query Language) ( sql )
0 Comments
Read More
Leave a Reply. |