Breaking Down an Oracle SQL Interview Question

preview_player
Показать описание


More from Jay:
  1. Jay Feng
  2. SQL
  3. Oracle
  4. Mock interview
  5. SQL Interview Question
  6. Oracle SQL
Рекомендации по теме
Oracle SQL Tutorial 0:04:55

Oracle SQL Tutorial 9 - Intro to Queries

Secret To Optimizing 0:05:57

Secret To Optimizing SQL Queries - Understand The SQL Execution Order

Oracle SQL Developer 0:09:39

Oracle SQL Developer Tutorial (Feature Demonstration)

Approach to Complex 0:08:33

Approach to Complex SQL Queries

20 Tips for 0:16:59

20 Tips for Oracle SQL Developer (To Save You Time)

Oracle SQL All-in-One 4:08:10

Oracle SQL All-in-One Quick Start Tutorial Series (4 HOURS!)

Oracle SQL Tutorial 0:10:18

Oracle SQL Tutorial 1 - Intro to Oracle Database

The five-step guide 0:25:59

The five-step guide to SQL tuning | CloudWorld 2022

Oracle SQLPLSQL (Day 1:03:36

Oracle SQLPLSQL (Day 2) (Batch 342)

Oracle SQL Tutorial 3:28:29

Oracle SQL Tutorial | Oracle DBA | Oracle SQL for Beginners | Great Learning

Oracle - SQL 0:14:47

Oracle - SQL - Managing Transactions

How to Find 0:11:16

How to Find Slow SQL: Databases for Developers: Performance #9

SQL Query Optimization 0:03:18

SQL Query Optimization - Tips for More Efficient Queries

An Introduction to 1:24:30

An Introduction to Oracle SQL

SQL Tutorial in 0:06:08

SQL Tutorial in Oracle - 1

SQL tutorial 60: 0:07:30

SQL tutorial 60: SQL View in Oracle Database By Manish Sharma RebellionRider

Oracle SQL Developer 0:10:52

Oracle SQL Developer Tool Tutorial

Oracle SQL Developer 1:13:14

Oracle SQL Developer - Full Course

Oracle SQL Developer: 1:04:26

Oracle SQL Developer: Product Demonstration

you need to 0:24:25

you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)

Oracle SQL Developer---Connections---Running 0:06:43

Oracle SQL Developer---Connections---Running SQL Queries

Tutorials#76 How to 0:07:11

Tutorials#76 How to create SYNONYM in Oracle SQL Database

SQL Server Tutorial 0:09:51

SQL Server Tutorial - One-to-many and many-to-many table relationships

Oracle - SQL 0:13:33

Oracle - SQL - Introduction

Комментарии
Автор

I think the query will not work if impression 1; they are excited, but in impression 2, for the same campaign, they are bored. A1 will grab the first value and won't join because a1.ds<a2.ds. I think this works:
with most_recent as
(select
user_id,
campaign_id,
max(ds) as most_recent_impression
from ad_impressions
group by
user_id,
campaign_id
)
select
mr.user_id,
mr.campaign_id
from most_recent mr
left join
ad_impressions ad on mr.user_id = ad.user_id
and mr.campaign_id = ad.campaign_id
and mr.impression_id != ad.impression_id
where mr.impression_id <> 'BORED'
and ad.user_id is null

LobmanTheLobster
Автор

hello brother how are you? please 🙏🙏 reply me brother (i am from India) love you bro ❤️❤️❤️❤️

ramraj