469,322 Members | 1,585 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,322 developers. It's quick & easy.

UPDATE query

Hello!I need to use an UPDATE clause instead of SELECT in the following script.Any help?Thank YOU!

select SALARIU,nume_profesor,
(case count(nume_sectie)
when 1 then SALARIU
when 2 then SALARIU*1.01
else salariu*1.03
end) noul_salariu
from tbl_profesor,tbl_catedra,tbl_sectie
where tbl_profesor.CATEDRA=tbl_Catedra.cod_catedra
and tbl_catedra.COD_CATEDRA=tbl_sectie.COD_CATEDRA
group by salariu,nume_profesor
May 3 '07 #1
0 1029

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Mike Leahy | last post: by
10 posts views Thread by Randy Harris | last post: by
7 posts views Thread by Mark Carlyle via AccessMonster.com | last post: by
31 posts views Thread by Lag | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by mdpf | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.