79135481

Date: 2024-10-29 00:40:41
Score: 1.5
Natty:
Report link
Select MAX(ID) AS ID, FileSize FROM DupTable 
GROUP BY FileSize
HAVING COUNT(*)=1

gives error: Circular reference cause by alias 'ID' in query definition's SELECT list

But the but the last SQL: Select * FROM DupTable WHERE FileSize in ( Select FileSize FROM DupTable GROUP BY FileSize HAVING COUNT(*)=1 ) is giving me the results I needed.

Thank You for the SQL and also teaching me about HAVING/WHERE

Reasons:
  • Blacklisted phrase (0.5): Thank You
  • Blacklisted phrase (0.5): I need
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (0.5):
Posted by: Alan