SQL Interview Question || Obtain Multiple Result From Same Input Table || Frequently Asked Question

Подписаться 1,8 тыс.

50% 1

In this video we see how to obtain multiple result from the same input table.
Table Script :-
create table sales_tab(id int, product varchar(20), sales int);
insert into sales_tab
values(1001,'Keyboard',20),
(1002,'Keyboard',25),
(1003,'Laptop',30),
(1004,'Laptop',35),
(1005,'Laptop',40),
(1006,'Monitor',45),
(1007,'WebCam',50),
(1008,'WebCam',55)
🔍 Looking for something specific? Check out my curated playlists.
✅Complex SQL Interview Questions
• Complex SQL Interview ...
✅SQL Interview Questions
• SQL Interview Questions
✅SQL Mastery Interview Prep
• SQL Mastery Interview ...
✅Learn SQL Concepts
• Learn SQL Concepts
✅SQL Functions
• SQL Functions
📩 Contact: For any inquiries or collaborations, please email me at dataprojecthub@gmail.com
Don't forget to hit the subscribe button and ring the notification bell to never miss an update! Become a valued member of our passionate community and be part of the journey with me!
Thanks for watching, and see you in the next video!" 🚀

Опубликовано:

23 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 2

@Ilovefriendswebseries 13 дней назад

Please come up with difficult questions sir

@vijaygupta7059 13 дней назад

Select * ,first_value(sales)over(partition by product order by id) as rn ,sum(sales)over(partition by product order by id) as rinning_total_sales from sales_tab order by id,product;