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.1K viewsOct 13, 2024
SQL Case When Tutorial
33- CASE in SQL | Conditional Logic and Case Statements in SQL Queries
9:29
33- CASE in SQL | Conditional Logic and Case Statements in SQL Queries
YouTubeTutorialsSpace- Er. Deepak
891 viewsMay 3, 2025
SQL Case Statement WHEN, THEN, ELSE, END with Coalesce() & NullIf() in SQL Complete Course 2025
20:00
SQL Case Statement WHEN, THEN, ELSE, END with Coalesce() & NullIf() in SQL Complete Course 2025
YouTubeTraidev Official
4.9K viewsFeb 28, 2025
Day 6: SQL CASE Statement with Real-World Examples
25:35
Day 6: SQL CASE Statement with Real-World Examples
YouTubeVishmita Data Labs
15 views3 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
63 views1 month 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.2K viewsMay 26, 2021
🔥 Capgemini SQL Interview Question | Find Consecutive Sequences in SQL Server
6:58
🔥 Capgemini SQL Interview Question | Find Consecutive Sequences in SQL Server
YouTubeThe Data -Tech Club
2K viewsFeb 21, 2025
SQL Case When Examples
SQL CASE WHEN Statement (Visually Explained) | #SQL Course 20
36:19
SQL CASE WHEN Statement (Visually Explained) | #SQL Course 20
YouTubeData with Baraa
55.8K viewsJun 26, 2024
Learn SQL CASE with Real Example | Explained Simply
2:33
Learn SQL CASE with Real Example | Explained Simply
YouTubeDebugging Miles
632 views6 months ago
SQL Made Easy: Master CASE WHEN with Simple & Multiple Conditions!
3:24
SQL Made Easy: Master CASE WHEN with Simple & Multiple Conditions!
YouTubeProgramming For Everybody
75 viewsFeb 9, 2025
FAANG SQL Interview Question #12 | Consecutive Filing Years | Gaps & Islands Trick
6:34
FAANG SQL Interview Question #12 | Consecutive Filing Years | Gaps & Islands Trick
63 views1 month 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.2K viewsMay 26, 2021
YouTubeLearn at Knowstar
🔥 Capgemini SQL Interview Question | Find Consecutive Sequences in SQL Server
6:58
🔥 Capgemini SQL Interview Question | Find Consecutive Sequences in SQL Server
2K viewsFeb 21, 2025
YouTubeThe Data -Tech Club
Practice Complex SQL Queries | SQL Query to fetch N consecutive records
25:33
Practice Complex SQL Queries | SQL Query to fetch N consecutive records
86.8K viewsSep 28, 2021
YouTubetechTFQ
33. Consecutive Numbers | SQL Interview Questions and Answers
5:59
33. Consecutive Numbers | SQL Interview Questions and Answers
7.4K viewsMar 31, 2024
YouTubeStart Practicing
Leetcode 180 - Find consecutive numbers from the table #sql #leetcode #sqlserver #coding
1:55
Leetcode 180 - Find consecutive numbers from the table #sql #leetcode #sqlserver #coding
6.8K views2 months ago
YouTubeThe Engineer's Desk
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
6.9K viewsSep 20, 2022
YouTubeLearn at Knowstar
13:21
Consecutive Days Problem using SQL | Data Science Problem
752 viewsJun 3, 2024
YouTubeHitesh Damani
9:41
SQL Query Interview Question - Scenario - No sales for n consecutive days | Identify date gaps
11.3K viewsJul 14, 2021
YouTubeLearn at Knowstar
3:53
Leetcode SQL: Find Consecutive Numbers | SQL Tutorial with Real Example
21 viewsApr 23, 2025
YouTubeGeeky Codes
SQL Amazing Trick | Calculate Yearly, Quarterly, Monthly totals in a single SQL Query |Grouping Sets
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
3:10
Oracle sql query to group consecutive records by date (2 Solutions!!)
4 views2 months ago
YouTubeRoel Van de Paar
4:21
SQL Interview Question | How To Find Consecutive Occurrences of a Number? Leetcode
528 views5 months ago
YouTubeLearn at Knowstar
1:08
SQL : Get distinct consecutive date ranges from overlapping date ranges
17 viewsMay 1, 2023
YouTubeHey Delphi
0:48
Find Customers with Consecutive Orders | SQL Interview Question & Answers | Advanced SQL Query
33.7K viewsMay 8, 2023
YouTubevirtbi projects
16:58
SQL Interview Query | How many times does a number occur consecutively | Leetcode | Consecutive Nums
7.2K viewsAug 30, 2022
YouTubeLearn at Knowstar
19:02
Coding Series - SQL : Consecutive Numbers At least 3 Times
369 viewsMar 22, 2024
YouTubeGrow with Data
7:35
Consecutive Numbers SQL Solution – LeetCode 180 Explained (PostgreSQL Tutorial)
25 views7 months ago
YouTubeSumanshu Nankana
Consecutive User Logins - SQL Interview Query 17 | SQL Problem Level "MEDIUM"
20:47
Find in video from 01:05Showcasing LearnSQL.com
Consecutive User Logins - SQL Interview Query 17 | SQL Problem …
17.7K viewsMar 17, 2024
YouTubetechTFQ
13:05
How to Calculate year-on-year (YoY) Growth in Sales Amount for each year?| SQL Interview Preparation
1.5K viewsApr 5, 2025
YouTubeNishtha Nagar
2:21
How to Calculate Years Worked in SQL (SYSDATE Trick!)
417 views10 months ago
YouTubeCape Shortz
59:46
SQL Interview Questions & Answers | Real Questions with Company Names | Part 2
8.7K views4 months ago
YouTubeShakra Shamim
6:23
SQL Query | How to find employees hired in last n months | Datediff
66K viewsFeb 2, 2021
YouTubeLearn at Knowstar
23:43
3 Very Important SQL Interview Questions on LeetCode | Practise SQL Questions
40.1K viewsApr 4, 2022
YouTubeSumit Mittal
6:56
Find numbers appearing consecutively in 3 or more rows | SQL interview Question For Data Science
697 viewsAug 31, 2022
YouTubeData Science PJ
6:16
Oracle SQL Practical question | Oracle query to display three consecutive days where cnt exceeds 100
2.3K viewsJan 6, 2025
YouTubeSiva Academy
8:03
180. Consecutive Numbers | LeetCode SQL Solution [MEDIUM]
1.2K viewsJun 17, 2022
YouTubeCode with Carter
9:43
SQL Interview Question: Longest Streak of Consecutive Sales
326 viewsJan 24, 2025
YouTubeCodeInQueries
See more