All pastes #472050 Raw Edit

Someone

public sql v1 · immutable
·published 2007-05-05 07:53 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 OverallReadCost, SUM(CPU) * COUNT(CAST(TextData as varchar(100))) as OverallCPUCostFROM LiveMay5GROUP BY CAST(TextData as varchar(100))HAVING ( COUNT(CAST(TextData as varchar(100))) > 10 )ORDER BY NumOccurrences DESC