- About us
- Services
- Skills
- Web Development
- ColdFusion Development
- SharePoint Development
- Classic ASP Development
- ASP.NET Development
- Modern ASP .Net Development
- DotNetNuke Development
- Java/JSP/servlets Development
- Python Development
- PHP Development
- Perl Development
- Ruby on Rails (RoR) Development
- Lasso Development
- Real Basic Development
- Google API Integration Services
- Mobile Development
- Database & Client server Development
- Plug-in Development
- Reports/BI Development
- Automated Testing
- QA/Testing Skills
- Domain-based Testing
- E-Commerce Development
- CMS Development
- Desktop Development
- RIA Development
- App-based development
- Salesforce Development
- SugarCRM Development
- Dynamics GP GreatPlains development
- Dynamics SL Solomon development
- Microsoft Dynamics CRM Consulting Development
- Dynamics RMS development
- LiveCycle development
- QuickBooks development
- Drupal development
- Joomla development
- Typo3 development
- Magento development
- Dolphin social development
- Others
- Web Development
- Industries
- Knowledge
- Process
- Models
- Clients
- Career
| |
Software Technology Tips
In MYSQL GROUP BY provide us a modifier called WITH ROLLUP, which will added an extra row to the output as a summary report.
SELECT IFNULL(`ContactId` , "GRAND TOTAL") AS 'CONTACT ID', SUM(`SalesTotal`) AS `TOTAL` FROM Sales GROUP BY `ContactId` WITH ROLLUP
|
||||||||||
Output:
You can't use the ORDER BY clause with the WITH ROLLUP. They are mutually exclusive. |
Related Tags:
Database, MySQL, Reporting
Author: Madhusmita Pradhan
Database
- Display summary report using a simple query in MYSQL
- MySQL: Implementing case-sensitive functionality in query
- MySQL: Using "ON DUPLICATE KEY UPDATE" while inserting record
- SQLSERVER Transaction rollback
- Using Regular Expressions with MySQL queries to Search
- TRY- CATCH in SQL SERVER 2005/2008
- How to get the Deleted Identity Numbers in SQL Server 2005
- Replace function in MySQL
- Backup SQL Database Through Code In VB.NET
- Get list of existing TRIGGERs in MYSQL
- Renaming Database Objects
- How to Escape Wildcard Characters While Searching in SQL Server
- How to swap data between columns in SQL Server
- Using SQL JOIN to get data from different tables conditionally
- Why not to use TEXT data type in SQL Server 2000
- SET and SELECT in SQL Server
- Retrieving List of DB created by user from SQL Express 2005
- Dealing with NULL values in SQL Server
- Executing SSIS package from local machine using C# code
- DATALENGTH() AND LEN()
- More Related Tips
