SQL Stored Procedure උදවු

[malan_de]

A	B	C	D	E
1000​	5​	2​	2018-A
1001​	15​	63​	2018-A
1002​	25​	124​	2018-A
1003​	35​	185​	2018-A
1004​	45​	246​	2018-A
1005​	55​	307​	2018-A
1000​	65​	368​	2018-B
1001​	75​	429​	2018-B
1000​	85​	490​	2018-C
1001​	95​	551​	2018-C
1002​	105​	612​	2018-C
1003​	115​	673​	2018-C
1004​	125​	734​	2018-C

මට ඕනි මාසයට(D -Coloum) අදලාව B*C කරලා E colum එක update කරගන්ට ඕනි මේක කරන්නේ කොහොමද .

මේ විදියට කරාම last එක විතරයි update වෙන්නේ .


select @A=A,@Ans=B*C from tblN where D='2018-A'
UPDATE tblN
SET E = @ANS
WHERE D='2018-A' and A=@A

 

[windows_ubuntu]

Up

---

Try chtgpt
------ Post added on Sep 17, 2023 at 2:30 PM

 

[malan_de]

Up

---

Try chtgpt
------ Post added on Sep 17, 2023 at 2:30 PM

thanks
set une ne

 

[gnilukshi]

Update t1
set t1.e=t2.b*t2. C
From tbl t1
Join tbl t2 on t1. A=t2 a
Where t1. D=2018-a

එච්චර ඕනත් නෑ වගේ

Update t1 set t1. E=t1. B*t1. C from tbl t1 where t1. D=2018-a

 

[Thilantdm]

use chatgpt bn...

 

[Solo Rider]

up

 

[Draco Malfoy]

mata mechchara kal gihiniuth karanna amaruma de thama sql. sql amuma amu basic tika karaganna puluwan. but join deka thunak damma gaman shaka boom wenawa mata. thadi proc ehema dakka gaman goo giya mata sinhalayo™ thama

 

[roshan fernando]

Update t1 Set t1.E = t1.B * t1.C From tblN t1

Okkoma rows walata update ekak yanawa meken, filter karanna onenam Where ekak daala filter karaganna

 

[Geshi95]

mata mechchara kal gihiniuth karanna amaruma de thama sql. sql amuma amu basic tika karaganna puluwan. but join deka thunak damma gaman shaka boom wenawa mata. thadi proc ehema dakka gaman goo giya mata sinhalayo™ thama

Same here

 

[windows_ubuntu]

Same here

Enna mn udaw krannm

 

[kinkon]

SQL Stored Procedure

 

[CorD SaC]

අවුල තියෙන්නෙ උබේ query එකේ

SELECT @A = a,
       @Ans = b * c
FROM   tbln
WHERE  d = '2018-A'

මෙහෙම කරපන්

UPDATE tbln
SET    e = b*c
WHERE  d = '2018-A'

 

[malan_de]

kastiyama thanks wade hari.

 

[HAneo]

A	B	C	D	E
1000​	5​	2​	2018-A
1001​	15​	63​	2018-A
1002​	25​	124​	2018-A
1003​	35​	185​	2018-A
1004​	45​	246​	2018-A
1005​	55​	307​	2018-A
1000​	65​	368​	2018-B
1001​	75​	429​	2018-B
1000​	85​	490​	2018-C
1001​	95​	551​	2018-C
1002​	105​	612​	2018-C
1003​	115​	673​	2018-C
1004​	125​	734​	2018-C

මට ඕනි මාසයට(D -Coloum) අදලාව B*C කරලා E colum එක update කරගන්ට ඕනි මේක කරන්නේ කොහොමද .

මේ විදියට කරාම last එක විතරයි update වෙන්නේ .


select @A=A,@Ans=B*C from tblN where D='2018-A'
UPDATE tblN
SET E = @ANS
WHERE D='2018-A' and A=@A

Calculated values ganne sub Query yanakota bro
meka simple ma update query ekak