MYSQL Basics to Know…..PART-3

 

MYSQL Basics to Know…..PART-3

AGGREGATE FUNCTIONS — collects a set of values to return a single value.

I have used my favorite comic data in creating a database and a table.

  1. The Vision, Volume 1: Little Worse Than A Man
  2. Batman: The killing Joke
  3. Venom, Volume 1: Homecoming
  4. Venom, Volume 2: The Abyss
  5. The Flash: A Celebration of 75 Years

COUNT(): counts the number of rows in a database.

COUNT() syntax
COUNT() syntax

MIN(): It shows the lowest number of values in a table.

MIN() syntax

MAX(): It shows the highest number of values in a table.

MAX() syntax

For MIN Title and pages. In this below syntax, it shows only Title and pages which is in ascending order and has a LIMIT -1 (which gives only 1 row of data).

For MIN Title and pages

The below syntax is based on descending order which can be also used for MAX() syntax.

ORDER BY()

SUM(): It calculates the sum of a selected set of columns.

SUM() syntax

AVG(): It calculates the average of a selected set of columns.

AVG() syntax

Comments

Post a Comment

Popular posts from this blog

MYSQL - “LIKE operator”

Image
  MYSQL - “LIKE operator” The LIKE operator is used in a WHERE clause to search for a pattern in a column. Two wildcards are often used while using the LIKE operator: Percentage sign( % ) — it represents multiple characters ,zero ,one. Underscore sign( _ ) — it represents single character. Create database before creating a table. commands : CREATE DATABASE pannts_db, USE pants_db creating pants_db table and inserting values LIKE ‘J%’ — finds any value that starts with “J” In the below syntax it shows the values from “ Article column ” where the value starts with “J” .  LIKE ‘J%’.  It shows only those values as per the condition described. LIKE ’J%’ LIKE ‘%e’ — finds any values that ends with “e” In the below syntax it shows the values from “ color column ” where the value ends with the letter ”e”.  LIKE ‘%e’.  It shows only those rows as per the condition described. LIKE ‘%e’ LIKE ‘%a%’ — finds any values that have or in any position. In the below syntax it shows values from “ Article
Read more