Question : I store the data from the rain gauge in mySQL and needed help with listing the data. I […]
Tag: max
MySQL – maximum of sum over different months [duplicate]
Question : This question already has answers here: MySQL – maximum of sum over different months with ties over multiple […]
Understanding varchar(max) 8000 column and why I can store more than 8000 characters in it
Question : From this Microsoft doc,+ n defines the string length and can be a value from 1 through 8,000. […]
MySQL NDB cluster maximum data size
Question : According to the limitations outlined at http://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations.html, there can only be 48 data nodes. Does that mean, with […]
What is the most compact way to calculate and then Update a maximum value for each day’s data?
Question : I have a database that stores records for each bundle of material. A sample is taken from each […]
max(max(col1), max(col2), …) does not work
Question : I have a table with three integer columns: select max(col1), max(col2), max(col3) from mytable I want the max […]
Find max and min date over multiple fields of the same record
Question : I have a table with 4 distinct data-type fields. For each record, I need to find the max […]
Postresql, max returns all rows with same ids
Question : System PostgreSQL 11.5 (Ubuntu 11.5-1.pgdg19.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 8.3.0-6ubuntu1) 8.3.0, 64-bit Issue Need return one […]
Find Max Value for each month for the last 3 months, properly
Question : I have a query going that gets data for an ID for the last 3 months. I need […]
Displaying a value associated with a maximum value
Question : I have a PostgreSQL database for a supermarket (it’s a toy problem) and I need to find which […]