Perez_Bottoms

Hello, I have a SQL database that I am trying to run and narrow it down quite a bit. The database is for a calendar, and for a school district, on the main district homepage, I want to display events from all four high schools, but only the NEXT one …

I have a somewhat complicated select query which returns, in part, the following resultset (as an example): [code=text] threadid views -------- ----- 1 5 1 5 2 10 3 15 4 10 [/code] If I were to do the following select: [code]COUNT (DISTINCT threadid), SUM (DISTINCT views)[/code] then it would …