| Author |
Topic |
|
srujanavinnakota
Starting Member
34 Posts |
 Posted - 2010-07-02 : 13:08:40
|
| Hi, Can anyone help me with the logic. I have a scenario where I need to check for the value 50 in OldVal and NewVal columns for each ID. No Matter where it is, If OldVAl Or NewVal is 50 then it need to pick up the ID.ID OldVal NewVal1 100 101 10 501 50 1501 150 1002 10 13 300 303 30 504 50 1004 100 50 4 50 1505 300 305 30 10Thanks In Advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
srujanavinnakota
Starting Member
34 Posts |
Posted - 2010-07-02 : 13:31:24
|
| Thanks for your help. Also can you please tell me how can I count the no of times it has been triggered to 50 in both oldval or newval columns. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2010-07-02 : 13:38:35
|
| SELECT ID,COUNT(*)FROM YourTableWHERE OldVal = 50 OR NewVal = 50GROUP BY ID |
|
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2010-07-02 : 13:39:32
|
Hmm...1 sec... |
|
|
|
srujanavinnakota
Starting Member
34 Posts |
|
|
srujanavinnakota
Starting Member
34 Posts |
Posted - 2010-07-02 : 13:40:21
|
Thank youquote:
Originally posted by vijayisonly
SELECT ID,COUNT(*)FROM YourTableWHERE OldVal = 50 OR NewVal = 50GROUP BY ID
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
Help with Row Comparison
I wasn't sure which one the OP wanted, so I went with the one that had less typing. 
Tara Kizer