Tredence SQL Interview Question - Find events with 3 or more consecutive years for each pid
8:11
YouTubeCloud Challengers
Tredence SQL Interview Question - Find events with 3 or more consecutive years for each pid
SQL question recently asked in Tredence interview. Find events with 3 or more consecutive years for each pid To find out the expected output, I use row_number() function. --Create table syntax CREATE TABLE events ( pid INT, year INT ) -- Insert data into the table INSERT INTO events VALUES (1, 2019), (1, 2020), (1, 2021), (2, 2022), (2, 2021 ...
8.6K viewsOct 13, 2024
SQL Case When Tutorial
Day 83 Stop Using IF-ELSE! Learn SQL CASE WHEN for Better Queries
13:26
Day 83 Stop Using IF-ELSE! Learn SQL CASE WHEN for Better Queries
YouTubeCode with Indhu
10 views1 week ago
Session#2 | CASE Statement in SQL | Basic to Advanced with Real-Time Examples
59:47
Session#2 | CASE Statement in SQL | Basic to Advanced with Real-Time Examples
YouTubeETL Automation with Yogesh
32.3K views2 months ago
SQL CASE Statement & CTE Explained 🔥 | Common Table Expression in MySQL
22:21
SQL CASE Statement & CTE Explained 🔥 | Common Table Expression in MySQL
YouTubeBtwitravi
29 views2 months ago
Top videos
FAANG SQL Interview Question #12 | Consecutive Filing Years | Gaps & Islands Trick
6:34
FAANG SQL Interview Question #12 | Consecutive Filing Years | Gaps & Islands Trick
YouTubeNishant Sethi
67 views3 months ago
SQL tutorial | How to find n consecutive date records | Sales for at least n consecutive days.
11:02
SQL tutorial | How to find n consecutive date records | Sales for at least n consecutive days.
YouTubeLearn at Knowstar
42.4K viewsMay 26, 2021
33. Consecutive Numbers | SQL Interview Questions and Answers
5:59
33. Consecutive Numbers | SQL Interview Questions and Answers
YouTubeStart Practicing
8.1K viewsMar 31, 2024
SQL Case When Examples
🔥 CASE WHEN in SQL Explained | Real-Time SQL Interview Concept 🚀
1:08
🔥 CASE WHEN in SQL Explained | Real-Time SQL Interview Concept 🚀
YouTubeCloud BI Academy
158 views1 month ago
Day 6: SQL CASE Statement with Real-World Examples
25:35
Day 6: SQL CASE Statement with Real-World Examples
YouTubeVishmita Data Labs
23 views5 months ago
7. SQL CASE Statement Explained (With Examples) | Intermediate SQL Tutorial
17:53
7. SQL CASE Statement Explained (With Examples) | Intermediate SQL Tutorial
YouTubeDee - Analyst
8 views2 months ago
FAANG SQL Interview Question #12 | Consecutive Filing Years | Gaps & Islands Trick
6:34
FAANG SQL Interview Question #12 | Consecutive Filing Years | Gaps & Islands Trick
67 views3 months ago
YouTubeNishant Sethi
SQL tutorial | How to find n consecutive date records | Sales for at least n consecutive days.
11:02
SQL tutorial | How to find n consecutive date records | Sales for at least n consecutive days.
42.4K viewsMay 26, 2021
YouTubeLearn at Knowstar
33. Consecutive Numbers | SQL Interview Questions and Answers
5:59
33. Consecutive Numbers | SQL Interview Questions and Answers
8.1K viewsMar 31, 2024
YouTubeStart Practicing
Practice Complex SQL Queries | SQL Query to fetch N consecutive records
25:33
Practice Complex SQL Queries | SQL Query to fetch N consecutive records
87K viewsSep 28, 2021
YouTubetechTFQ
ADVANCED SQL 🔥 Consecutive Numbers Problem | 3 Approaches Explained
23:17
ADVANCED SQL 🔥 Consecutive Numbers Problem | 3 Approaches Explained
525 views2 months ago
YouTubeBigDataYatra
SQL Query | How to find 'n' consecutive days EXCLUDING Weekends | LAG | Windows function | streaks
26:09
SQL Query | How to find 'n' consecutive days EXCLUDING Weekends | LAG | Windows function | streaks
7K viewsSep 20, 2022
YouTubeLearn at Knowstar
ADVANCED SQL 🔥 Consecutive Logins | LAG/LEAD + Self Join Explained
20:01
ADVANCED SQL 🔥 Consecutive Logins | LAG/LEAD + Self Join Explained
46 views2 months ago
YouTubeBigDataYatra
0:51
Coding Series - SQL : Consecutive Numbers At least 3 Times #python #sqlfordataengineer #coding #sql
1.4K viewsMar 22, 2024
YouTubeGrow with Data
6:58
🔥 Capgemini SQL Interview Question | Find Consecutive Sequences in SQL Server
2.1K viewsFeb 21, 2025
YouTubeThe Data -Tech Club
4:21
SQL Interview Question | How To Find Consecutive Occurrences of a Number? Leetcode
606 views8 months ago
YouTubeLearn at Knowstar
3:49
Enumerate years between two dates with calculated values (3 Solutions!!)
7 views2 months ago
YouTubeRoel Van de Paar
8:22
SQL Interview Question:Calculate Sales by Year Using Recursive CTE|Generate Dates Like Pro! (Day 15)
57 views2 months ago
YouTubeData-2-Dollars
3:53
Leetcode SQL: Find Consecutive Numbers | SQL Tutorial with Real Example
25 viewsApr 23, 2025
YouTubeGeeky Codes
1:17
SQL Query for Year‑Over‑Year Growth Explained
655 views5 months ago
YouTubeData by Jundi
3:10
Oracle sql query to group consecutive records by date (2 Solutions!!)
6 views4 months ago
YouTubeRoel Van de Paar
1:16
SQL Server Tutorial | How to Search Data by Year (Step-by-Step Guide)
57 views2 months ago
YouTubeProgramming For Everybody
1:55
Leetcode 180 - Find consecutive numbers from the table #sql #leetcode #sqlserver #coding
7.1K views4 months ago
YouTubeThe Engineer's Desk
16:58
SQL Query to find consecutive numbers. Session 35
317 viewsSep 22, 2024
YouTubeSunny@Pandita
0:30
SQL Tricks | How To Identify Leap Years #sqltricks #fallintoshorts
1.7K views9 months ago
YouTubeLearn at Knowstar
1:41
SQL | Generate Series in SQL: 3 Ways for Numbers & Dates
443 views7 months ago
YouTubeLearn at Knowstar
16:58
SQL Interview Query | How many times does a number occur consecutively | Leetcode | Consecutive Nums
7.2K viewsAug 30, 2022
YouTubeLearn at Knowstar
2:08
HOW TO SET YEAR END IN SQL ACCOUNT
1.8K views7 months ago
YouTubeeSoft SQL
2:21
How to Calculate Years Worked in SQL (SYSDATE Trick!)
419 viewsJul 17, 2025
YouTubeCape Shortz
6:38
SQL Aggregate Functions | COUNT, SUM, AVG, MAX, MIN | #SQL Course 21
25.7K viewsMar 21, 2025
YouTubeData with Baraa
59:46
SQL Interview Questions & Answers | Real Questions with Company Names | Part 2
9.6K views6 months ago
YouTubeShakra Shamim
6:16
Oracle SQL Practical question | Oracle query to display three consecutive days where cnt exceeds 100
2.4K viewsJan 6, 2025
YouTubeSiva Academy
15:27
Find in video from 01:02Calculating Yearly Totals
SQL Amazing Trick | Calculate Yearly, Quarterly, Monthly totals i…
23.2K viewsAug 9, 2022
YouTubeLearn at Knowstar
13:06
How to Calculate year-on-year (YoY) Growth in Sales Amount for each year?| SQL Interview Preparation
2.1K viewsApr 5, 2025
YouTubeNishtha Nagar
9:43
SQL Interview Question: Longest Streak of Consecutive Sales
335 viewsJan 24, 2025
YouTubeCodeInQueries
See more
Static thumbnail place holder