#sql

Veröffentlicht am: 15 Januar 2023
auf dem Kanal: Daily life of a Data Engineer

1,658

Hi All,
My name is Ankit Shrivastava and I am a Data Engineer.
Today this #vlog is regarding #sql How to handle NULL while aggregation or performing any mathematical calculation.

Please find the below DDL for practice:-

create table product_sales (prd_id int,sale_amt int)
insert into product_sales values (1,100);
insert into product_sales values (2,200);
insert into product_sales values (3,null);
insert into product_sales values (4,300);

#sqlinterviewquestions #dataanalyst #dataengineering #dataanalysis

Please find the link of my all previous videos:-
#sql Calculate start & end time and average time spent in successful transaction | startup interview
Link    • #sql Calculate start & end time and a...

#sql to achieve last NOT NULL value from the record | Analytical Function | Data Engg | Data Analyst
Link    • #sql to achieve last NOT NULL value f...

#sql to identify Top Performing Product every Quarter of each year | Highest sale every quarter
Link    • #sql to identify Top Performing Produ...

#sql Interview Question - Calculate Running Total | Cumulative sum | UNBOUNDED PRECEDING FOLLOWING
Link    • #sql Interview Question - Calculate R...

#sql Interview question - Schedule cricket match between teams and generate points table using SQL
Link https://lnkd.in/dsM8Pe8B

#sql Interview Questions - All JOINS (INNER, LEFT, RIGHT, FULL OUTER) | JOIN only NULL values
Link https://lnkd.in/dJttWQBB

#sql Interview Question - What is the difference between COUNT(*), COUNT(1) and COUNT(-1)
Link https://lnkd.in/dVHMWxKj

#SQL Interview Question - How to delete duplicate record from table
Link https://lnkd.in/dcVyhC7X

#SQL Interview Question -Second highest salary using dense rank analytical function
Link https://lnkd.in/daBumQfB

#SQL to pull unique record after combination of column

#SELFJOIN
Link https://lnkd.in/d6tXYXCv

Auf dieser Seite können Sie das Online-Video #sql mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Daily life of a Data Engineer 15 Januar 2023 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 1,658 Mal angesehen und es wurde von 46 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!

749