#sql

Publicado el: 15 enero 2023
en el 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

En esta página del sitio puede ver el video en línea #sql de Duración hora minuto segunda en buena calidad , que subió el usuario Daily life of a Data Engineer 15 enero 2023, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 1,658 veces y le gustó 46 a los espectadores. Disfruta viendo!

749