advanced code snippet search

Posted By

kashif21 on 04/12/11


Tagged


Versions (?)

selecting single value in multiple columns (with respect to first column and without the respect of the first Column)

 / Published in: SQL
 
Expand | Embed | Plain Text 
  1. WITH respect TO first COLUMN:
  2.  
  3. SELECT * FROM Issue WHERE AssignedEmployeeID=45 AND (LocalTesterID=43 OR StagingTesterID=43 OR FinalTesterID=43)
  4.  
  5.  
  6. WITH out the respect of first COLUMN:
  7.  
  8. SELECT * FROM Issue WHERE AssignedEmployeeID=45 AND LocalTesterID=43 OR StagingTesterID=43 OR FinalTesterID=43

Report this snippet  

You need to login to post a comment.