Skip to main content

GroTechMinds

GroTechMinds logo

AGGREGATE FUNCTION IN SQL

AGGREGATE FUNCTION IN SQL

  • July 9, 2024
  • Posted by: Radha R
No Comments

Welcome to your AGGREGATE FUNCTION IN SQL

1. Aggregate functions should not be used in the ‘where’ clause we can use them in the ‘have’ clause.

2. Which aggregate function is used to find the maximum number?

3. Which aggregate function is used to find the sum of values?

4. select avg(salary) as avg_salary is a correct syntax?

5. Display the number of rows present in any table.

6. Display the maximum salary from the employee table.

7. How many types of aggregate functions are there?

8. What is the 'min' aggregate function?

9. Display the minimum salary from the employee table.

10. Which function is used to find the count of values?

Leave a Reply

GroTechMinds logo

GroTechMinds is a well-known technical education platform working in the domain of Software Testing, Digital Marketing ,Software Development, Databases, Analytics, and Cloud Technologies, started with an aim to educate technical aspirants to gain knowledge, develop skills and build a successful career in the technology space.

Facebook-f Instagram Twitter Linkedin Youtube
Company
Join with us
Valuable References
Get Our Application
Explore Now
Software testing Course
Latest Blogs
CONTACT

2022 © All Rights Reserved By GroTechMinds