Канал: Daily life of a Data Engineer

#sql Interview question to identify range of status with given date #dataengineering #dataanalytics

#sql Interview question to identify range of status with given date #dataengineering #dataanalytics

#sql query to find all numbers that appear at least three times consecutively #dataanalysts #data

#sql query to find all numbers that appear at least three times consecutively #dataanalysts #data

#sql - Multiple ways to create table in #database | with data, without data, with filter condition

#sql - Multiple ways to create table in #database | with data, without data, with filter condition

#sql - Calculate business day between two dates including weekend, holiday and if holiday on weekend

#sql - Calculate business day between two dates including weekend, holiday and if holiday on weekend

#aws S3-IAM-Redshift | Copy data from S3 to Redshift and vice versa using IAM role & policy #amazon

#aws S3-IAM-Redshift | Copy data from S3 to Redshift and vice versa using IAM role & policy #amazon

#sql interview question How to achieve Organisational hierarchy using self join from one table | DE

#sql interview question How to achieve Organisational hierarchy using self join from one table | DE

#sql Count occurence of character in a string / Count occurrence of word in a sentence #data analyst

#sql Count occurence of character in a string / Count occurrence of word in a sentence #data analyst

#sql - difference between WHERE & AND clause with LEFT/RIGHT join | INNER join+WHERE=LEFT join+WHERE

#sql - difference between WHERE & AND clause with LEFT/RIGHT join | INNER join+WHERE=LEFT join+WHERE

#sql How to handle NULL while aggregation | SUM() | AVG() | Data Analyst | Data Engineer |Math calc

#sql How to handle NULL while aggregation | SUM() | AVG() | Data Analyst | Data Engineer |Math calc

#sql Calculate start & end time and average time spent in successful transaction | startup interview

#sql Calculate start & end time and average time spent in successful transaction | startup interview

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

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

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

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

#sql Interview Question - Calculate Running Total | Cumulative sum | UNBOUNDED PRECEDING FOLLOWING

#sql Interview Question - Calculate Running Total | Cumulative sum | UNBOUNDED PRECEDING FOLLOWING

#sql Interview question Schedule cricket match between teams and generate points table using SQL

#sql Interview question Schedule cricket match between teams and generate points table using SQL

#sql Interview Questions - All JOINS (INNER, LEFT, RIGHT, FULL OUTER) | JOIN only NULL values output

#sql Interview Questions - All JOINS (INNER, LEFT, RIGHT, FULL OUTER) | JOIN only NULL values output

#sql Interview Question - What is the difference between COUNT(*), COUNT(1) and COUNT(-1)

#sql Interview Question - What is the difference between COUNT(*), COUNT(1) and COUNT(-1)

#SQL Interview Question - How to delete duplicate record from table

#SQL Interview Question - How to delete duplicate record from table

#SQL Interview Question -Second highest salary using dense rank analytical function || 3rd highest

#SQL Interview Question -Second highest salary using dense rank analytical function || 3rd highest

#SQL - Interview Question- SQL to pull unique record after combination of column #SELFJOIN

#SQL - Interview Question- SQL to pull unique record after combination of column #SELFJOIN

#SQL - Interview Questions - Join on duplicate values all four joins (INNER, LEFT, RIGHT, FULL OUTER

#SQL - Interview Questions - Join on duplicate values all four joins (INNER, LEFT, RIGHT, FULL OUTER