Home Forums SQL Server 2005 T-SQL (SS2K5) Two Variable Combination Permutation Calculation RE: Two Variable Combination Permutation Calculation

  • February 17, 2011 at 7:16 am

    #1288214

    SELECT MIN(qry_id), MAX(qry_id), hic_number

    FROM Table1

    GROUP BY hic_number

    HAVING COUNT(*) = 2

    N 56°04'39.16"
    E 12°55'05.25"