What is an SQL ... Window functions are often more efficient and maintainable for calculations across related rows, while subqueries are useful for filtering and aggregating data based on conditions.

I realized how much easier my life would be if SQL had a mode() aggregate function. (I'm using it in ... I suppose I should try to write a stored procedure to do it. <BR>(Also, I'm mostly a ...