XP is just a number | |
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
Thanks. ;-)
I first had this idea 12 years ago, during a first year C programming lecture at University. The professor declared in the class that if you want to swap the values of two variables, you have to do it with a temporary variable: I challenged his declaration and provided the following solution The lecturer was amazed and gave me an 'A' for the subject. *grin* The solution set order_id=11-order_id where order_id in (5,6) is just another variant of the same trick. Update: Thanks rkg to point out the missing bit. My memory got rusty. The original challenge was to swap the values without using a third temporary variable. In reply to Re: Re: Re: non-perl SQL question
by Roger
|
|