KPMG SQL INTERVIEW QUESTION | JSON input

Published: 16 October 2024
on channel: Data Sculptor

1,074

Join this channel to get access to perks:
   / @datasculptor2895

Feedback: https://forms.gle/NQuCAy7p5a9wxW3LA

DML:

DROP TABLE IF EXISTS Customers;

CREATE TABLE Customers
(
[Name] varchar(100),
[PurchaseDetails] nvarchar(max)
);

INSERT INTO Customers
VALUES
('Bob', '[{"Month": "January", "Amount": "1000"}]'),
('Alice', '[{"Month":"January","Amount":"2000"},{"Month":"February","Amount":"500"},{"Month":"March","Amount":"2000"}]');

Playlists:
SQL Interview Questions:    • SQL Interview questions
Recursive CTE:    • Recursive CTE
PySpark Interview Questions:    • PySpark Interview Questions
Power BI and DAX:    • Power BI and DAX
Data Modeling:    • Data Modelling
Generative AIs:    • Generative AIs
Excel:    • Excel
Cricket:    • Cricket
SQL ADVANCED AGGREGATIONS:    • ADVANCED AGGREGATIONS SQL

Follow me
Linkedin:   / data-sculptor-93a00b2a8
Instagram:   / datasculptor2895

On this page of the site you can watch the video online KPMG SQL INTERVIEW QUESTION | JSON input with a duration of hours minute second in good quality, which was uploaded by the user Data Sculptor 16 October 2024, share the link with friends and acquaintances, this video has already been watched 1,074 times on youtube and it was liked by 51 viewers. Enjoy your viewing!

206