need queryThis is a discussion on need query within the Microsoft SQL Server forums in category; i want to check whether a value exists in a table's row with some condition. actually the value may exists any of the column's value. is it possible with exists??? i tried the following query SELECT '9912' FROM table1 AS T1 WHERE EXISTS (SELECT * FROM table1 AS T2 WHERE T1.val2 ='HR1203' AND T2.val2 = T1.val2); but it is not correct... plese need a help........ | ||||||||
| | ||||||||
| ||||||||
| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
08-07-2008, 03:22 AM
|
 need query i want to check whether a value exists in a table's row with some condition. actually the value may exists any of the column's value. is it possible with exists??? i tried the following query SELECT '9912' FROM table1 AS T1 WHERE EXISTS (SELECT * FROM table1 AS T2 WHERE T1.val2 ='HR1203' AND T2.val2 = T1.val2); but it is not correct... plese need a help.....  |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
All times are GMT -4. The time now is 01:51 PM.
