This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
sql_analysis_dedup_attachments [2014/09/01 23:01] daniel |
sql_analysis_dedup_attachments [2018/09/09 19:53] daniel |
||
---|---|---|---|
Line 15: | Line 15: | ||
</code> | </code> | ||
- | This query retrieves, within the top 30 of the most deduplicated attachments (in number of occurrences), the count and sizes of attachments with file names and a significant size: | + | The following query retrieves, within the top 30 of the most deduplicated attachments (in number of occurrences), the count and sizes of attachments with file names and a significant size: |
<code sql> | <code sql> | ||
select filename,count(*),content_size | select filename,count(*),content_size |