Posted By

kashif21 on 04/12/11


Tagged


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

Beppoi


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


 / Published in: SQL
 

  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.