summaryrefslogtreecommitdiff
path: root/graphs/sql/vault_cataloging/req03.sql
blob: 12dd9cfe86e06ba0d0c0770c288c24aa34b85339 (plain)
1
2
3
4
5
6
7
8
9
10
11
SELECT
    filename,
    LEAST(rsa_time,hyper_pulse_time,quantum_x_time,aes_time,d_crypt_time) AS best_time,
    GREATEST(rsa_time,hyper_pulse_time,quantum_x_time,aes_time,d_crypt_time) AS worst_time
FROM dtf.madelines_files_results
ORDER BY (
    CASE
        WHEN filename LIKE '.%' THEN 1
        ELSE 2
    END
),filename