Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT TableA.Id,TableA.UserId,TableA.MaximumHp,TableA.Attack,TableA.Defense,TableA.SpAttack,TableA.SpDefense,TableA.Speed
- FROM myTable as TableA
- Inner Join myTable as TableB on
- TableA.MaximumHp = TableB.MaximumHp
- AND TableA.Attack = TableB.Attack
- AND TableA.Defense = TableB.Defense
- AND TableA.SpAttack = TableB.SpAttack
- AND TableA.SpDefense = TableB.SpDefense
- AND TableA.Speed = TableB.Speed
- AND TableA.Id <> TableB.Id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement