User Tools

Site Tools


sql_analysis_dedup_attachments

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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
sql_analysis_dedup_attachments.txt ยท Last modified: 2018/09/09 19:53 by daniel