In SQL, the ___________ function returns the average value of a numeric column.
- AVG()
- SUM()
- COUNT()
- MAX()
The correct option is "AVG()." The AVG() function in SQL is used to calculate the average value of a numeric column in a table. It excludes NULL values while calculating the average.
Loading...
Related Quiz
- How does the Proxy design pattern differ from the Decorator design pattern?
- You're designing a file system where efficient directory traversal is crucial. Would you choose a tree-based or graph-based structure for representing directories and files? Justify your choice.
- Your team is developing a web application where users frequently search for articles based on keywords. How would you implement index-based search to improve query performance?
- How does the Shortest Job First (SJF) scheduling algorithm minimize average waiting time?
- What is the difference between static routing and dynamic routing protocols?