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!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. 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=&quot;ab&quot;) and ( float >= 0.000000 and float <= 200000.000000 ))) group by float,sd HAVING (sd = &quot;ab&quot;) or (sd =...

Part and Inventory Search

Back
Top