A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
update query feasible solution
Joined: Jun 22, 2010
Mar 25, 2011 04:35:14
My Requirement is updating the emp table, sal column
if sal>=2000 and <3000 add 2000
if sal>=3000 and <4000 add 3000
if sal>=4000 and <5000 add 5000
you can do this in many ways.but what is the feasible solution?
author & internet detective
Joined: May 26, 2003
Mar 25, 2011 08:00:48
How many ranges do you have? If just the thre, I would use three update statements? If a lot, I would use a stored procedure.
How To Ask Questions The Smart Way
Blogging on Certs:
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
With a little knowledge, a
cast iron skillet
is non-stick and lasts a lifetime.
subject: update query feasible solution
Get Maximum sal from emp table
Best Way to Edit a Byte Array
How to pass arraylist in methods?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014