Inner, Left, Right & Full Outer Joins Explanation with Gate-2018 Question | Lets Crack GATE-2022

DBMS Notes: File 1: https://drive.google.com/file/d/14bXNQ8BRqYj_F5Q0h9kjCu5dBV_-Yc3h/view?… File 2: https://drive.google.com/file/d/1O4KdWod2jd3ja5kK62Fskqst-Wkz80R4/view?… Contributed by: Anurag Singhal Other subject playlist Link: -------------------------------------------------------------------------------------------------------------------------------------- ►Theory of Computation

ER Model based GATE-2018 Question | DBMS

DBMS Notes: File 1: https://drive.google.com/file/d/14bXNQ8BRqYj_F5Q0h9kjCu5dBV_-Yc3h/view?… File 2: https://drive.google.com/file/d/1O4KdWod2jd3ja5kK62Fskqst-Wkz80R4/view?… Contributed by: Anurag Singhal Other subject playlist Link: -------------------------------------------------------------------------------------------------------------------------------------- ►Theory of Computation

How Aggregate Functions work on NULL Values | SQL | DBMS

DBMS Notes: File 1: https://drive.google.com/file/d/14bXNQ8BRqYj_F5Q0h9kjCu5dBV_-Yc3h/view?… File 2: https://drive.google.com/file/d/1O4KdWod2jd3ja5kK62Fskqst-Wkz80R4/view?… Contributed by: Anurag Singhal CODE: Step1: Create table t1 ( A int, B int); Step2: Insert into t1 values(1,null); Insert into t1 values(2,null); Insert into t1 values(3, null); Insert into t1 values(4,null); Insert into t1 value