#sql
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
On this page of the site you can watch the video online #sql with a duration of hours minute second in good quality, which was uploaded by the user Daily life of a Data Engineer 15 January 2023, share the link with friends and acquaintances, this video has already been watched 1,658 times on youtube and it was liked by 46 viewers. Enjoy your viewing!
