Day 5 : SQL Tutorial in Hindi
#ritajainlectures #sqltutorialInHiindi
What we Learn on day 5
00:00 1 Introduction
5:00 2. Group By Command
10:00 3. Aggregate functions sum(), Max(), avg(), count(). min()
15:00 4. Summary
Important queries
use EMPLOYEE;
show tables;
select * from employee;
select count(*) as 'total employees' from employee;
select gender, count(gender) as "employess count" from employee group by gender;
select gender, max(gross) as "max salary" from employee group by gender;
select gender, avg(gross) as "avg salary" from employee group by gender;
select grade from employee group by grade order by grade asc;
select grade, max(gross) as 'max grossin each group' from employee group by grade order by grade asc;
select grade, max(gross) as 'max grossin each group' from employee group by grade having max(gross)=50000;
Play list Lin for SQL tutorial in Hindi
• SQL 5 Days Tutorial in Hindi
channel link
/ @jainrita
En esta página del sitio puede ver el video en línea Day 5 : SQL Tutorial in Hindi de Duración hora minuto segunda en buena calidad , que subió el usuario Rita Jain 14 febrero 2022, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 90 veces y le gustó 2 a los espectadores. Disfruta viendo!
