LEAD amp LAG in SQL Analytical Functions Advanced SQL Ashutosh Kumar

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=0B_6Q1E4H6Y

Sql one of the most important language asked in most of the analytics interviews,in this series i have discussed some advanced level sql concepts that are frequently asked in data analyst,business analyst interviews. In this video i have covered lead lag functions concepts in sql which comes in window functions. • 👉 Link to excel file - • https://github.com/ashutoshkr103/Micr... • #code for 1st table • drop table if exists details; • CREATE TABLE details(train_no INT, station VARCHAR(200), Timing TIME); • INSERT INTO details(train_no , station , Timing) • VALUES(22863,'Howrah','10:50:00'), • (22863 ,'Kharagpur','12:30:00'), • (22863 ,'Balasore','13:52:00'), • (22863 ,'Cuttack','15:47:00'), • (22863 ,'Bhubaneswar','16:25:00'), • (12262 ,'Howrah','05:45:00'), • (12262 ,'Tatanagar','09:00:00'), • (12262 ,'Bilaspur','15:05:00'), • (12262 ,'Raipur','16:37:00'), • (12262 ,'Nagpur','20:55:00'); • select * from details; • • 👉 Complete playlist on Sql Interview questions and answers • • HackerRank SQL problems and solution • --------------------------------------------------------------------------------------------------------------------- • Check out some more relevant content here • 👉 How to Learn SQL • • How to learn sql for beginners | Step... • 👉 How to become a business analyst complete roadmap- • • Business Analyst Complete Roadmap in ... • 👉 How to become a data analyst complete roadmap- • • Data Analyst Complete Roadmap in 2022... • 👉 Top 3 you tube channels to learn sql for free for beginners • • Video • 👉 Rank ,Dense Rank, Row Number in sql - • • RANK - DENSE RANK - ROW NUMBER IN SQL • 👉 Cross join in sql • • CROSS JOIN SQL • 👉 union join in sql • • UNION IN SQL • 👉 left join in sql • • LEFT JOIN IN SQL • 👉 Right join in sql • • RIGHT JOIN IN SQL • 👉 Inner join in sql • • INNER JOIN IN SQL • 👉 Introduction to tables and databases in sql - • • INTRO TO TABLES AND DATABASES IN SQL ... • 👉 Aggregate Function in sql • • AGGREGATE FUNCTION IN SQL • 👉 Functions in sql- • • IMPORTANT FUNCTIONS IN SQL • 👉 String Function in sql • • STRING FUNCTIONS IN SQL • 👉 CRUD operations in sql • • CREATE- READ- UPDATE-DELETE CRUD IN SQL • 👉 Autoincrement in sql • • Auto Increment in SQL - SQL • 👉 Primary Key in sql- • • PRIMARY KEYS IN SQL - SQL • 👉 Null and Default values in sql- • • NULL AND DEFAULT VALUES IN SQL - SQL • 👉 Data types in sql- • • Data types in Sql - SQL • ____________________________________________________________________ • Fill the form below to subscribe yourself to the analytics jobs mailing list to receive regular job opening updates - https://docs.google.com/forms/d/e/1FA... • Why you should definitely fill the analytics job updates google form - • Job Openings into business analyst da... • _______________________________________________________________________ • Connect with me • • 📸Instagram - / ashutosh.analytics • 💻Linkedin- / ashutoszh • _____________________________________________________________________ • Comment down if you have any doubts • Please leave a LIKE 👍 and SUBSCRIBE ❤️ to my channel to receive more amazing content in data analytics and data science. • _____________________________________________________________________ • 🏷️ Tags • • sql, • sql for data science, • sql for data analytics, • sql practise questions, • sql practise questions and solutions, • sql tutorials for beginners, • sql problems for data engineers, • ashutosh, • ashutosh kumar, • ashutosh kumar analytics, • sql problems easy, • sql problem medium, • sql problems hard, • sql window functions, • sql advanced questions, • rank functions in sql, • lag lead in sql, • sql interview questions and answers, • sql interview questions, • sql questions asked in interviews, • hackerrank sql solutions, • hackerearth sql solutions, • leetcode sql solution • 🏷️HashTags • #sql #interviews #questions #solutions

#############################

New on site