SQL Server Performance

Sql query pblm

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by haneesh, Feb 21, 2008.

  1. haneesh New Member

    Suppose a table contains fields such as member_id,item1,item2 and item3.Then how can we fetch common items between two rows. eg:- mem_id item1 item2 item3 1 a b c 2 b c d 3 d f g common items between first 2 rows is 'b' and 'c'. How can we write a query for this. thanks in advance
  2. Madhivanan Moderator

Share This Page