Advertisement
Guest User

Untitled

a guest
Dec 28th, 2011
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.45 KB | None | 0 0
  1. SELECT TableA.Id,TableA.UserId,TableA.MaximumHp,TableA.Attack,TableA.Defense,TableA.SpAttack,TableA.SpDefense,TableA.Speed
  2. FROM myTable as TableA
  3. Inner Join myTable as TableB on
  4. TableA.MaximumHp = TableB.MaximumHp
  5.   AND TableA.Attack = TableB.Attack
  6.   AND TableA.Defense = TableB.Defense
  7.     AND TableA.SpAttack = TableB.SpAttack
  8.       AND TableA.SpDefense = TableB.SpDefense
  9.         AND TableA.Speed = TableB.Speed
  10.        AND TableA.Id <> TableB.Id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement