#sql

Published: 27 May 2023
on channel: Daily life of a Data Engineer

338

Hi All,
My name is Ankit Shrivastava and I am a Data Engineer.
Today this #vlog is regarding #sql - Multiple ways to create table in #database | with data, without data, with filter condition
DDL for practice:-
CREATE TABLE emp1 (id integer, name varchar(50));

insert into emp1 values(1,'A');
insert into emp1 values(2,'B');

Please find the link of my all previous videos:-
#aws S3-IAM-Redshift | Copy data from S3 to Redshift and vice versa using IAM role & policy #amazon

• #aws S3-IAM-Redsh...

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

• #sql interview qu...

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

• #sql Count occure...

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

• #sql - difference...

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

• #sql How to handl...

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

• #sql Calculate st...

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

• #sql to achieve l...

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

• #sql to identify ...

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

• #sql Interview Qu...

#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

#SQL Join on duplicate values all four joins (INNER, LEFT, RIGHT, FULL OUTER)
Link https://lnkd.in/d9HcwkZs

#dataengineering #etl #dataanalysts #dataanalysis #bigdata #business

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 27 May 2023, share the link with friends and acquaintances, this video has already been watched 338 times on youtube and it was liked by 7 viewers. Enjoy your viewing!

13,912

323