# Questions tagged [max]

Maximum value. Largest, biggest, greatest.

6,207 questions
33 views

### How to find local maximum in R from graph

I'm having a problem with my coding. I'm supposed to Plot a graph of this equation [y=f(x)] where f(x) = (10*((x-1)^2)^(1/3))/(x^2 + 9) for 10001 values of x between (and including) -5 and 5 Among ...
24 views

### How to export 3dmax Scene to FBX or other Format used by Unity-3D?

I'm working on VRChat Room ... i needed Kitchen , so i found beauty free 3d model, it's awesome, but ... there is problem. it has a .max extension which i can not use. I searched for online converters,...
43 views

### SQL combined maximum value of two columns

i have a table with three columns +------+------------+----------+ | item | date | sequence | +------+------------+----------+ | a | 30/11/2017 | 1 | | a | 30/11/2017 | 2 | |...
35 views

### Same logic is working for c++ but not in python for maximum in stack,is there something that i am missing in my code

I have written same logic in python and c++ to return maximum element in a stack in O(1) time using two stacks. but when I submitted it on hackerrank it is showing wrong answer for python but ...
8 views

### Return date based on another cell's criteria

I am trying to find a formula that will return the first and last date based on criteria from another cell. I'm assuming that I will need to use MIN and MAX but I can't seem to figure out how. I've ...
13 views

### Calculate average of: max based on unique value in another column Excel pivot and PowerBI

I've built a process which results in a table on SQL Server with data as seen in the image below which is then connected to Excel/PowerBI for reporting. Dept Lvl 1 is the highest in the hierarchy and ...
15 views

### Tableau - Filter Dimension on Max Value of Measure

I'm trying to calculate the MAX value of column D of value E which resets for every A Column. Later I just need to show the MAX row of A. Raw data looks like this: The desired view would be like ...
35 views

### An incrementing function in php going wrong

I have prepared a php function which gets the MAX value in a row, then adds '1' to the number. So that whenever I register a new stage, it prepares the MAX value for the next stage to be registered. ...
52 views

### How to check if an integer larger than Integer.MAX_VALUE [duplicate]

Suppose I have an positive int x; I want to double x until it is larger than Integer.MAX_VALUE then stop. I know MAX_VALUE = 2^31-1 and if x goes beyond this value, overflow occurs, and x becomes ...
54 views

### How to find max value in 2D array with index [duplicate]

I want to find some elegant way, how to find max value in 2D array with indexes in python. I used np.amax(array) for searching max value, but I don't know how to get indexes. Of course, I could ...
47 views

### My minimum section isn't showing the real minimum(Solved)

#include<stdio.h> int main(){ float a[100],sum=0.0,avg,havg[100],min,max; int i; for(i=0; i!=-1;i++){ printf("Enter number : "); scanf("%f",&a[i]); max = a[0]; min = a[0]; ...
19 views

### SSRS (Report Builder) Min Value and Max Value from Same Dataset

I am attempting to extract data from a database that has an error in it. I can't resolve the error (it's a "design feature"), so i have to try to query around it. Here's how it is stored. Record ID | ...
31 views

### PyTables retrieve maximum and minimum values?

I've created a Python script which receives time-series data off a socket and writes it via PyTables to an HDF5 file like so: #Define description object to pass to the table constructor class ...
20 views

### How to get the maximum value between specific index of pandas column?

I have a dataframe which has date index and pool of positive and negative values values = [1,2,3,4,-1,-2,-3,10,11,12] start_date = pd.to_datetime('2019-01-23') dates = [start_date + datetime....
29 views

### Find the max(key) from the dictionary(all keys are integers) and print the values-Python

First of all my apology as the title is somewhat confusing. There are a lot of forums that shows how to find the max key based on value. What I need is to find a way to capture the max key, example: ...
45 views

### MySQL Select min and max time in each group [closed]

I want mysql to select only min time and max time in each record. How code would be? Database is for ontime and working time status for each machine in one day. My Target Result is | DATENM | ...
24 views

### Iterating numpy array to find max value within subarray leaving the row index

I wanted to find the max of 2D array along the axis=0 and I don't want to include the value at the row-index. I'm not happy with this solution because I need to run this on a million of rows and I don'...
23 views

### how sumarize time difference between min begin_date and max end_date - mysql

Have a "orders" table with 1 record: +--------+---------+---------+------------+ |ID_ORDER | DESC_ORDER | NUMBER_ORDER | +----------+---------+--------------------+ | 19 | TEST | ...
35 views

### (MATLAB) How to obtain the max and min background of a series of images?

I'm having troubles on how to obtain the max and min of the background of a series of images. I made this function which calculates the mean by adding all the pixel values and then divide by a total ...
50 views

### Google Sheets - formula to return N first values from range A where MAX(range B)

F1:N1 with random numbers (can have duplicates). F2:N2 with sorted numbers. Need a formula to fill in A1:C1 with values from F2:N2 where F1:N1 has a maximum value. In the example it should be 1,8,3 ...
30 views

### Time Complexity bounds for approximate maximum of a sequence/array

Given a sequence x[1], x[2], ..., x[N] for a very large N. For any e, d > 0 find xhat such that with probability at least 1 - d, xhat lies within exp(e) factor of the maximum of x[1], x[2], ..., x[...
27 views

### sql get newest date and price of all inventory_items

I have this sql tables, and i need to get from all inventory items the newest date from table: orders with the price paid on this date table:orders id date table:order_items order_id inventory_id ...
30 views

### mysql - select most recent value with where

I have a table like below (lets called this table as t1) +----+---------------------+---------+-----------------------+-------+-------------+ | id | timestamp | p_value | TS ...
44 views

### Matlab code to identify the maximum peak (coordinate) of a polynomial curve

I have this set of x and y data that would fit into a polynomial curve. Is there any way using Matlab (or Excel) to graph this data, trace a polynomial fit to it, and identify the (x,y) coordinate ...
32 views

### SQL select distinct value where Status = MAX

I have a Table ErpInformations. OrderId PartNo Status 4711 | 1510 | 0 4711 | 1511 | 0 4711 | 1512 | 1 4712 | 1513 | 3 4712 | 1514 | 0 4713 | 1515 | 0 4713 | 1516 | ...
28 views

### How to run a formula until max or threshold value

I am searching for an answer to the question below. I am creating individual-level life tables in excel and only need the formula to run until a max possible age of 100. I am using the excel formula ...
44 views

### SQL Server : getting the max and min of a sum aggregate

I have a list of orders for products with a ProductID and the quantity ordered. For example: ProductID Quantity ------------------ 1 5 2 2 3 5 1 2 3 4 ...
47 views

### MAX function on one column, return all columns

I'm using SQL Server and I'm trying to get the MAX of Res when Res is a varchar, and I want to group by pID, but also keep the in the final result. aID | Res | pID 1 | Yes | 94 2 | Yes | 32 3 ...
38 views

### min and max funcion to calculate minimum credit card balance [closed]

I am trying to write Python code using the minimum and maximum functions to calculacte miinimum balance on a credit card. it is calculated like this:. The minimum payment is equal to either \$10 or 2....
33 views

### Fill a column based on max values by condition in R

I need to fill a new column based on the max values per group. So I have A B C 1 1 0 1 9 0 2 5 0 2 10 0 2 15 0 3 1 0 3 2 0 4 5 0 4 6 0 I need to fill \$C with 1 for each maximum value in \$B ...
31 views

### Advice on running formula until max value

I am a grateful user of stack overflow – thanks to the community. This is my first time posting. I am creating individual-level life tables in excel and only need the command to run until a max ...
25 views

### Get only a sublist with a lowest value at specific index

I've got a list [[1, 2, 48.5], [1, 3, 66.7], [1, 4, 32.4]] and I want to only get a list with the lowest value at index of 2 so that I only get a list like this [1, 4, 32.4] I have tried messing ...
44 views

### get the values mit highets value sql

the following table is given (in Oracle); LVL KID FATHER 1 POD001 DPR001 1 POD002 DPR002 1 POD003 POD002 2 POD003 DPR002 2 POD004 DPR001 1 POD004 POD001 2 POD005 POD002 ...
76 views

### Find Min/Max Values from List grouped by Object Identifier

I'm trying to find the largest and smallest value in an group of items with same attributes. For example from the screenshot, the max value for crop: 18157 would be 1.77 and the smallest 1.68 ...
21 views

### Making a specific value required in html without showing that value in the text box

I would like to show a calculation as specified below, where a right answer is required: <p style="font-family:calibri;">2 + 27 – 7 + 3 – 9 – 3 = &emsp;&emsp; Result: <input ...
13 views

### Error in function max() for 3 number in python [duplicate]

I'm beginner in python but I don't understand a thing. This is the Code: a = input("Insert first number ") b = input("Insert second number ") c = input("Insert third number ") print("Max number is", ...
36 views

### How to get a Max Value from a dict in python with multiples elements

I am having a hard time time trying to get the Name of the element with the MAx Value: Here is the Json example: { 'id':'bbb', 'project':'8', 'iteration':'34', 'created':'2019-03-...
62 views

### Retrieving datalength along with columns and tables in SQL Server query

Because I want to convert the columns to not be varchar(MAX) I want to see the maximum datalength for each column to decide what the new size should be. I have this query for finding all my (n)...
25 views

### select min (lowest) or max (bigest) from array float number

Halo people. There is possible to select select min (lowest) or max (bigest) from array float number? Im try min(array) and max(array) but not working? I can not found on manual. Can you help me? ...
37 views

### Creating a CGRect that encompasses a UIBezierPath and NSArray x Array in the process

All I need to do is to create a CGRect that encompasses a UIBezierPath and I have an array of CGPoint. To create this CGRect all I need to do is to enumerate the array of CGPoint and find the minimum ...
29 views

### post_max_size does not change

I changed post_max_size in the php.ini file and then restarted my webserver with sudo systemctl restart apache2 However when I try to import a db file then I get the error (Max: 2,048KiB) Also ...
36 views

### How to set Max Length on ag-grid cells

Is there any way to impose a maxLength text allowed in an ag-grid cell, similar to the one on a normal input element? <input maxlength="220"/> No relative documentation found. Also, no ...
33 views

### Calculating the score of fields using MAX and MIN

The query's objective in brief is to list all the posts according to its score, which is calculated according to a calculate scores of date, views, and rating SELECT p.id , p.date ...
23 views

### value matching based on common names + max value of an additional field? (R)

I'm trying to subset a dataframe for sons with a common father who have the heaviest weight. See the sample data below. va <- c("tom", "john", "regis") df1 <- data.frame(va) names(df1) <- "...
13 views

### How to Select Maximum Value in Crystal Report

I am working on a report with several columns and one of its columns is a Cheque Number. I need to capture the highest check number and display it on the report footer. Here is some sample data: ...
27 views

### MySQL CASE WHEN numb IS NULL ignore record WHERE numb IS NOT NULL

I have these data in a table: numb m value 8070 1 7.63 NULL 1 7.64 NULL 1 7.65 8070 2 7.939 8070 2 7.935 8070 2 7.941 NULL 3 7.62 8070 4 7.92 8070 4 ...
64 views

### R - maximum value of variables when compared between levels of variable1 grouped by variable2

Consider the following data set.seed(123) example.df <- data.frame( gene = sample(c("A", "B", "C", "D"), 100, replace = TRUE), treated = sample(c("Yes", "No"), 100, replace = TRUE), resp=rnorm(...
23 views

### Modifying an exchange PHP script for min max

I'm running a crypto exchange site with a PHP script, but my script has no min max settings in the admin area. Does anybody have an idea how to modify the input form or change the script? Code: <...
65 views

### SQL Max Value for a Specified Limit

I'm trying to return a list of years when certain conditions are met but I am having trouble with the MAX function and having it work with the rest of my logic. For the following two tables: ...
64 views

### Finding the max of an int and a double?

How do I obtain the max value of both the given int and double values? package _pasted_code_; import java.util.Scanner; public class extra { public static void main(String[] args) { ...

http://mssss.yulina-kosm.ru