Plataformas
Android Smartphone, Tablet, PC Windows, Linux, Mac OS X, BSD,
Whats New » Ativador Windows 8 Single Language 64 Bits
plataformas
Android Smartphone, Tablet, PC Windows, Linux, Mac OS X, BSD,
windows 8 enterprise single language | Windows 8 Enterprise Build 9200
Articles
Windows 8.1 Review | Windows 8.1 is Here. And it’s Better | Windows 8.1 Review.. ativador windows 8 enterprise build 9200 single language deve ser lido em português..
Category:Activators
Category:Windows 8Q:
MySQL Workbench - Report from separate tab
I am wondering how I can make a query output report in MySQL Workbench. I want to create a report with the maximum value of each column that matches a particular condition.
I do not want to use a stored procedure.
I am using the MySQL Workbench.
Any help is appreciated.
A:
You can use the Viewer to make a table. However, there's nothing like a stored procedure in the viewer, it's just a graphical interface that show you the data as tables and columns.
To sum up the columns by maximum value, I suggest you to create the following view:
SELECT
column1,
column2,
column3,
MAX(column4) AS max_column4,
MAX(column5) AS max_column5,
MAX(column6) AS max_column6,
MAX(column7) AS max_column7,
MAX(column8) AS max_column8,
MAX(column9) AS max_column9,
MAX(column10) AS max_column10,
MAX(column11) AS ac619d1d87
Related links: