-1

Can anyone please tell me the difference where to use union and where to use uinon all in mysql

Satyam Koyani
  • 4,236
  • 2
  • 22
  • 48
Ankit Gupta
  • 189
  • 12

1 Answers1

1

UNION gets distinct values, UNION ALL doesn't.

Mahmoud Gamal
  • 78,257
  • 17
  • 139
  • 164