Day 5 : SQL Tutorial in Hindi

Опубликовано: 14 Февраль 2022
на канале: Rita Jain

#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