Row Number in SQL Server | Use this function to increase the capacity of Excel
ฝัง
- เผยแพร่เมื่อ 9 ก.ย. 2024
- Create table Items_Target (Sl_no int,
Item_Name varchar(20),
Price Int,
Qty Int,
Total Int);
Insert Into Items_Target (Sl_no, Item_Name, Price, Qty, Total)
Values (1, 'Coffee', 50, 2, 100),
(2, 'Burger', 250, 3, 750),
(3, 'Pizza', 350, 4, 1400),
(4, 'Noodles', 200, 5, 1000),
(5, 'Momo', 150, 6, 900),
(6, 'IceCream', 50, 7, 350),
(7, 'Pastry', 60, 4, 240),
(8, 'Snacks', 25, 5, 125),
(9, 'Mashroom', 350,4,1400),
(10, 'Sushi', 50, 2, 100);