diff options
author | Helmut Grohne <helmut@subdivi.de> | 2013-03-06 15:36:49 +0100 |
---|---|---|
committer | Helmut Grohne <helmut@subdivi.de> | 2013-03-06 15:36:49 +0100 |
commit | e275749f97e7fef77a4e2f452a9abffde39025f0 (patch) | |
tree | 569612653a4596a3f32cf21d64a178d50c65eb6a | |
parent | 4a35c7d54a9c45c185e45c7ec8b74cbaa34f63f3 (diff) | |
download | debian-dedup-e275749f97e7fef77a4e2f452a9abffde39025f0.tar.gz |
README: added interesting query
-rw-r--r-- | README | 2 |
1 files changed, 2 insertions, 0 deletions
@@ -31,3 +31,5 @@ SQL database by hand. Example queries: SELECT a.package, a.filename, b.package, b.filename, a.size FROM content AS a JOIN content AS b ON a.hash = b.hash WHERE (a.package != b.package OR a.filename != b.filename) ORDER BY a.size DESC LIMIT 100; SELECT hash, sum(size)-min(size), count(*), count(distinct package) FROM content GROUP BY hash ORDER BY sum(size)-min(size) DESC LIMIT 100; + + SELECT package, filename, size FROM content WHERE function = "image_sha512" AND filename NOT LIKE "%.png"; |