MySQL Count Sum Min Max Avg Tutorial in Hindi / Urdu

Показать описание

In this tutorial you will learn mysql count, sum, min, max, avg functions tutorial in Hindi, Urdu.You can learn how to count whole record in data table of database, calculate average of any column, minimun and maximum number in any column.

PHP Tutorial in Hindi Playlist

MySQL Tutorial in Hindi / Urdu Playlist

Official Website

Follow us on Facebook

Follow us on Twitter

#mysql #webdevelopment #php

Рекомендации по теме

Комментарии

Dear sir a big thanks to you for this series. i did not attend whole labs of this subject but before some hours for final lab exam i watched this series and get more knowledge which i did not get in my whole semester

shahzaibhassan

Yahoo bhai aap kaha rehte ho, kaun ho ye janne ki bahut iccha hai, itne acche or puri lagan se padhane wale kahi nahi milte hain or sath me aavaj or padhane ka tarika dono ka talmel bahut hi uttam hai. Aap to bas ekdam superstar teacher ho youtube par. Bhai ko salute.

budgetarena

Thank you so much sir,
I watched your all video of MySQL
And learnt from scratch
And i switched into technical from non technical
And I got selected in infoys.
Thank you so much sir🙏🙏

interestingFact

Your videos are simple and easy to understand, , just make one video for find nth highest salary, , nth minimum salary.

sibasisdash

Sir, syntax is wrong to get the data of max & min percentage correct syntax is select MAX(percentage) as percentage, name, city from personal where percentage = (select max(percentage) from personal); . I'm writting this cause first i tried your syntax but it not works well.

vinodabnani

name returned in min percentage query is the name of first row...
if you run query of max percentage with name also then the name returned will be of first row

unknownrandoms

Helpful tutorial... Thanks for a video😇

monikadesai

tell me sir percentage ka column kese add kra hai & sir ur tutorial is too good and easy understand and thanq so much sir

shivam_vlogs

Sir min cmd i can use but when i am giving who has that min record means as you said name and city that is showing error for me some group by expression.

shaikhabusufiyan

kind request to the tutor, don't teach the wrong syntax.
Correct Code for getting details of the student having a minimum percentage. ==>

select * from student.personal where percentage = (select min(percentage) from student.personal);

axaysagathiya

You are great sir.
These videos are so helpful.

I have a question sir:
Suppose I made a student record using php and mysql and there is a column for fee.
And suppose i have made a search box where by typing the month or day we get record of that particular month or day
Now the result shown by search column also includes fee column.
What to do if i have to add all the amount of fee column which we get by searching for a particular day or month?

rp

Awesome vedio thnk you so much sir for that,

trtofficial.

Thank you very so much for this video sir :)

dhruvrajsinhjadeja-vfxarti

name returned in min percentage query is the name of first row...
if you run query of max percentage with name also then the name returned will be of first row please solve these qjuery

singh

Can you please show how we can add this percentage column and add data in it?

ShayistaAli-lyzp

Sir ager kisi ki second highest percentage dekhni ho toh kia query use kare gay

umairiqbal

When we use select max(SALARY) AS Salary, name, city from employee;
Its given back fst column name city not max salary holder

puneetmalik

Sir its not giving the exact values of other rows could you please help?

nilanjankarmakar-ht

sir Select min(percentage) as per, name, city it not working in mysql 8.0.33 error code 1140. in aggregated query without group by expression thats the error plz help me out

RahulYadav-qgxi

Select min(percentage) as Percentage, name, city from personal2;
Not working
My sql version: 8.0.26
Error Code: 1140. In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column 'student.personal2.name'; this is incompatible with sql_mode=only_full_group_by

mrperfectgaurav

MySQL Count Sum Min Max Avg Tutorial in Hindi / Urdu

Basic Aggregate Functions in SQL (COUNT, SUM, AVG, MAX, and MIN)

MySQL: Aggregatfunktionen (MIN, MAX, COUNT) (deutsch)

Functions in MySQL are easy

Mysql Count Sum Min Max Avg Tutorial | MYSQL

MySQL Avg, Min, Max, Count, Sum -- Aggregate functions

MySQL:max,min,avg,count,sum

MySQL Count Sum Min Max Avg Tutorial in Hindi / Urdu

SQL Aggregate Function (Avg / Min / Max / Sum / Count) Practical With Mysql

How To: Aggregate Functions In MySQL (3 Min) | AVG, SUM, COUNT, MIN, MAX with GROUP BY, ORDER BY

Tutorial mysql (count,sum,min,max,avg)

MAX(), MIN(), COUNT(), AVG(), and SUM() functions in MySQL

Lec-67: SQL Aggregate Functions - SUM, AVG(n), COUNT, MIN, MAX Functions | DBMS

13 Aggregate Functions in mysql | Sum, Count, Avg, Min, Max, First, Second #mysql

MySQL Aggregate Functions: SUM, MIN, MAX & AVG - Complete Tutorial

MySQL Aggregate Function : SUM, AVG, MIN, MAX, COUNT Functions | SQL Tutorial with Best Examples

MySql Tutorial #16: Aggregate function like Max,Min,Avg,Sum,count etc

Aggregate Functions in MySQL | COUNT | SUM | MIN | MAX | GROUP BY

Class 12 IP / CS || MySQL Aggregate Functions || MAX, MIN, AVG, SUM, COUNT

MySQL Aggregate Functions Tutorial MIN, MAX, AVG, SUM, COUNT Explained .

#MYSQL Dersleri - SUM , AVG , COUNT , MIN , MAX KULLANIMI

Advanced Aggregate Functions in SQL (GROUP BY, HAVING vs. WHERE)

MySQL Aggregation Operators: COUNT, SUM, AVG, MIN, MAX | Day 5 Of MySQL Mastery

SQL - Part 33 - avg(), max(), min(), count() and sum() MySQL Aggregate Functions

Funções de Agregação no SQL (SUM, COUNT, AVG, MIN e MAX) - Curso de SQL - Aula 4