#sql

Publicado em: 15 Janeiro 2023
no canal de: 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

Nesta página do site você pode assistir ao vídeo on-line #sql duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Daily life of a Data Engineer 15 Janeiro 2023, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 1,658 vezes e gostou 46 espectadores. Boa visualização!

749