説明
Complex SQL Questions for Interview Preparation | SQL Interview Question | SQL Tutorial for Beginner
Please use the below query to get the data in your database.
Create Table Cricket
(Year Int,
Player_Name Varchar(20),
Innings Int,
Runs Int,
Balls Int,
Outs Int,
HS Int,
Fifty Int,
Hundred Int,
Four Int,
Six Int)
Insert into Cricket Values (2021,'Shubman Gill',2,120,90,2,80,1,10,1,3)
Insert into Cricket Values (2022,'Rohit Sharma',8,249,218,6,76,3,0,31,12)
Insert into Cricket Values (2022,'KL Rahul',9,251,313,9,73,2,0,17,7)
Insert into Cricket Values (2021,'Rohit Sharma',12,560,650,3,37,2,0,15,0)
Insert into Cricket Values (2021,'KL Rahul',12,600,650,11,108,1,1,11,6)
Insert into Cricket Values (2021,'Virat Kohli',15,400,500,3,66,2,0,10,1)
Insert into Cricket Values (2022,'Shubman Gill',15,450,622,9,130,4,1,69,10)
Insert into Cricket Values (2022,'Virat Kohli',16,850,950,11,113,2,1,32,2)
Insert into Cricket Values (2023,'KL Rahul',24,1060,1208,16,111,7,2,93,18)
Insert into Cricket Values (2023,'Virat Kohli',24,1377,1389,19,166,8,6,122,24)
Insert into Cricket Values (2023,'Rohit Sharma',26,1255,1072,24,131,9,2,131,67)
Insert into Cricket Values (2023,'Shubman Gill',29,1584,1503,25,208,9,5,181,41)
In this video, I will teach you How to prepare yourself for the SQL Interview Question. Yes, it is a difficult to understand but I make it so simple with simple method and guidance.
Please watch this video only few videos are available on this topic of this Excel query
Most Popular Videos are:-
1) Most Powerful formula of Excel is DGET : https://www.youtube.com/watch?v=uLTpCDiFKWs
2) SQL Tutorial for Beginners in Hindi | SQL Kya Hota Hai in Hindi : https://www.youtube.com/watch?v=GbePTB2vMro
3) How to calculate Shrinkage and Attrition rate Formula in Excel Hindi : https://www.youtube.com/watch?v=Lc1anyh-5CQ
4) Create an interactive expense dashboard in excel : https://www.youtube.com/watch?v=ZgXntCE0DZU
5) Excel Logical Functions IF AND OR NESTED IF in Hindi By TeachToeach : https://www.youtube.com/watch?v=Us1wr2QrrlM
6) What is Power Bi in Hindi | Power BI Tutorial for Beginners in Hindi | पावर बी क्या होता है : https://www.youtube.com/watch?v=3lqVkGEUeRc
7) Excel Vlookup Formula Error NA REF VALUE in Hindi : https://www.youtube.com/watch?v=JlF8amcQS2A
8) Data Table in Excel in Hindi : https://www.youtube.com/watch?v=zCspzTjn9qA
9) How to write Query to Fetch Data with Salary in SQL || Logical Operators : https://www.youtube.com/watch?v=F8igWIKu4Xg
10) Reverse Lookup Formula Vlookup with Choose Function in Excel Hindi By TeachToEach : https://www.youtube.com/watch?v=n8rcnbOrFYY
#SQLEASY Way to Make Excel Dynamic CALENDAR | Excel me CALENDAR Kaise Banaye
In this video, I will teach you about How to make Dynamic Calendar in excel. Yes, it is a difficult to understand but I make it so simple with simple method and guidance.
Please watch this video only few videos are available on this topic of this Excel query
Most Popular Videos are:-
1) Most Powerful formula of Excel is DGET : https://www.youtube.com/watch?v=uLTpCDiFKWs
2) SQL Tutorial for Beginners in Hindi | SQL Kya Hota Hai in Hindi : https://www.youtube.com/watch?v=GbePTB2vMro
3) How to calculate Shrinkage and Attrition rate Formula in Excel Hindi : https://www.youtube.com/watch?v=Lc1anyh-5CQ
4) Create an interactive expense dashboard in excel : https://www.youtube.com/watch?v=ZgXntCE0DZU
5) Excel Logical Functions IF AND OR NESTED IF in Hindi By TeachToeach : https://www.youtube.com/watch?v=Us1wr2QrrlM
6) What is Power Bi in Hindi | Power BI Tutorial for Beginners in Hindi | पावर बी क्या होता है : https://www.youtube.com/watch?v=3lqVkGEUeRc
7) Excel Vlookup Formula Error NA REF VALUE in Hindi : https://www.youtube.com/watch?v=JlF8amcQS2A
8) Data Table in Excel in Hindi : https://www.youtube.com/watch?v=zCspzTjn9qA
9) How to write Query to Fetch Data with Salary in SQL || Logical Operators : https://www.youtube.com/watch?v=F8igWIKu4Xg
10) Reverse Lookup Formula Vlookup with Choose Function in Excel Hindi By TeachToEach : https://www.youtube.com/watch?v=n8rcnbOrFYY
#excel #sqlserver #teachtoeache