MySQL Forums
Forum List  »  Microsoft SQL Server

GROUP BY ALL
Posted by: Bas Manniƫn
Date: August 22, 2005 06:11AM

I have to migratie my queries from MSSQL (T-SQL) to MySQL.

I'm using the ALL keyword in the GROUP BY clause to get also the records which return zero.

If you use ALL, the query results include all groups produced by the GROUP BY clause, even if some of the groups have no rows that meet the search conditions. Without ALL, a SELECT statement that includes GROUP BY does not show groups for which no rows qualify.

Is there a method in MySQL to get the same result?

Options: ReplyQuote


Subject
Written By
Posted
GROUP BY ALL
August 22, 2005 06:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.