Practice Complex SQL Queries | SQL Query to fetch N consecutive records
Practice Complex SQL Queries | SQL Query to fetch N consecutive records
In this video, I explain how to write a complex SQL query which is to fetch N consecutive records from a table based on some condition. We see how to write a generic SQL Query to fetch any number of consecutive records from a table.
We see 3 different variations of writing this query:
1) How to write this query when the table has a primary key column
2) How to write this query when the table DOES NOT have a primary key column
3) How to write this query based on Date field value.
All the queries and scripts mentioned in this video are posted on my blog. You can download them for free from below link:
https://techtfq.com/blog/learn-how-to-write-sql-queries-practice-complex-sql-queries
Timestamp:
00:00 Intro
01:08 SQL Query to fetch N consecutive records from a table which has a primary key
14:52 SQL Query to fetch N consecutive records from a table which does not have a primary key
18:46 SQL Query to fetch N consecutive records from a table based on date field
🔴 WATCH MORE VIDEOS HERE 👇
✅ SQL Tutorial - Basic concepts:
https://www.youtube.com/playlist?list=PLavw5C92dz9HQQ_COgGb7kf_1H8UWUBxO
✅ SQL Tutorial - Intermediate concepts:
https://www.youtube.com/playlist?list=PLavw5C92dz9FD9XspliRM_HZM_jK7tkii
✅ SQL Tutorial - Advance concepts:
https://www.youtube.com/playlist?list=PLavw5C92dz9GbmgiW4TWVnxhjMFOIf0Q7
✅ Practice Solving Basic SQL Queries:
https://www.youtube.com/playlist?list=PLavw5C92dz9F66P3GFo5O6nJ4DfZNhVsp
✅ Practice Solving Intermediate SQL Queries:
https://www.youtube.com/playlist?list=PLavw5C92dz9EIYmNXJ8ZtQ1bmLIpt0SpV
✅ Practice Solving Complex SQL Queries:
https://www.youtube.com/playlist?list=PLavw5C92dz9Fahr7taauUx5RnTfuGyL--
✅ Data Analytics Career guidance:
https://www.youtube.com/playlist?list=PLavw5C92dz9FDsr995DjwCy9XNaIukb8P
✅ SQL Course, SQL Training Platform Recommendations:
https://www.youtube.com/playlist?list=PLavw5C92dz9GqF1Q_zn8KnYvFgtEOh-2n
✅ Python Tutorial:
https://www.youtube.com/playlist?list=PLavw5C92dz9FePZXIo4jpsupqp3X0w2SW
THANK YOU,
Thoufiq
Видео Practice Complex SQL Queries | SQL Query to fetch N consecutive records канала techTFQ
In this video, I explain how to write a complex SQL query which is to fetch N consecutive records from a table based on some condition. We see how to write a generic SQL Query to fetch any number of consecutive records from a table.
We see 3 different variations of writing this query:
1) How to write this query when the table has a primary key column
2) How to write this query when the table DOES NOT have a primary key column
3) How to write this query based on Date field value.
All the queries and scripts mentioned in this video are posted on my blog. You can download them for free from below link:
https://techtfq.com/blog/learn-how-to-write-sql-queries-practice-complex-sql-queries
Timestamp:
00:00 Intro
01:08 SQL Query to fetch N consecutive records from a table which has a primary key
14:52 SQL Query to fetch N consecutive records from a table which does not have a primary key
18:46 SQL Query to fetch N consecutive records from a table based on date field
🔴 WATCH MORE VIDEOS HERE 👇
✅ SQL Tutorial - Basic concepts:
https://www.youtube.com/playlist?list=PLavw5C92dz9HQQ_COgGb7kf_1H8UWUBxO
✅ SQL Tutorial - Intermediate concepts:
https://www.youtube.com/playlist?list=PLavw5C92dz9FD9XspliRM_HZM_jK7tkii
✅ SQL Tutorial - Advance concepts:
https://www.youtube.com/playlist?list=PLavw5C92dz9GbmgiW4TWVnxhjMFOIf0Q7
✅ Practice Solving Basic SQL Queries:
https://www.youtube.com/playlist?list=PLavw5C92dz9F66P3GFo5O6nJ4DfZNhVsp
✅ Practice Solving Intermediate SQL Queries:
https://www.youtube.com/playlist?list=PLavw5C92dz9EIYmNXJ8ZtQ1bmLIpt0SpV
✅ Practice Solving Complex SQL Queries:
https://www.youtube.com/playlist?list=PLavw5C92dz9Fahr7taauUx5RnTfuGyL--
✅ Data Analytics Career guidance:
https://www.youtube.com/playlist?list=PLavw5C92dz9FDsr995DjwCy9XNaIukb8P
✅ SQL Course, SQL Training Platform Recommendations:
https://www.youtube.com/playlist?list=PLavw5C92dz9GqF1Q_zn8KnYvFgtEOh-2n
✅ Python Tutorial:
https://www.youtube.com/playlist?list=PLavw5C92dz9FePZXIo4jpsupqp3X0w2SW
THANK YOU,
Thoufiq
Видео Practice Complex SQL Queries | SQL Query to fetch N consecutive records канала techTFQ
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
SQL Cricket Match Problem | Solving SQL Interview ProblemFrom 16 years of CAREER GAP To becoming a Software Engineer | How to get a JOB after a career gap3 SQL Queries Asked in Interview for Business Analyst - SolvedCourses You Can Take To Get Into Data AnalyticsSolving a Real SQL Interview Problem | Job Vacancies SQL QueryPython Bootcamp for Beginners | Python Course | Live TrainingSQL Data Analytics Project (PART 3) | Data Analyst Portfolio ProjectSQL Data Analytics Project (PART 2) | Data Analyst Portfolio ProjectSQL Data Analytics Project (PART 1) | Data Analyst Portfolio ProjectLearn SQL from me | Live SQL Training | SQL BootcampLearn Python here | Learn Python Programming hereSolving a Complex SQL Interview problem | Practice SQL QueriesREAL SQL Interview Problem | Hierarchical data in SQLComplete guide to Database Normalization in SQLSQL Live class on Lighthall | Learn SQL from Basic to Advance in SQL BootcampHow to learn SQL for free | Roadmap to learning SQLSolving an SQL Interview ProblemSolving SQL Interview Query | Find Tree Node type using SQLSolving SQL Interview Query for Data Analyst asked by a Product based companySolving a tricky SQL Interview QuerySQL Interview Query for Data Analyst