Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by cshokie
-
group by and having with multiple clauses
This is the select statement I have now... select distinct(float), count(id) from data_table where float in (select distinct(float) from data_table where ( (sd="ab") and ( float >= 0.000000 and float <= 200000.000000 ))) group by float,sd HAVING (sd = "ab") or (sd =...
