All pastes #472044 Raw Edit

Something

public sql v1 · immutable
·published 2007-05-05 07:49 UTC
rendered paste body
SELECT CAST(TextData as varchar(100)),COUNT(CAST(TextData as varchar(100))) AS NumOccurrences, SUM(READS) as Reads, SUM(READS) * COUNT(CAST(TextData as varchar(100))) as OverallCostFROM LiveMay5GROUP BY CAST(TextData as varchar(100))HAVING ( COUNT(CAST(TextData as varchar(100))) > 10 )ORDER BY NumOccurrences DESC