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
On this page of the site you can watch the video online Day 5 : SQL Tutorial in Hindi with a duration of hours minute second in good quality, which was uploaded by the user Rita Jain 14 February 2022, share the link with friends and acquaintances, this video has already been watched 90 times on youtube and it was liked by 2 viewers. Enjoy your viewing!
