Hot answers tagged

3 votes

Duplication records with INNER JOIN

If you only need to see rows from MessagesPerf and not MessagesPerfHistory, using an EXISTS subquery will avoid row duplication. Of course, you may see incorrect results with the NOLOCK hint in place, ...
Erik Darling's user avatar
  • 38.9k
1 vote

Out of my depth with post mysql 8 update (Warning: #1287 Setting user variables within expressions is deprecated)

This is a sample solution. Please customize this solution as you want. (Updated 2023-12-10 8.35am IST) SELECT base.property_name, base.room_number, base.customer_first_name, base....
SammaDev's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible