How to get max value of a column based on value of another column?
aldoblack
In my Database I have a table called ARTICLES. In ARTICLES I have 2 columns.
Now I want to get the max value of NRRENDORDOK column where the TIP column has value 'A'.
e.g. the max number of cells A in TIP column is 8.
Any help will be appreciated.
Michael Mairegger
You should take use of the MAX function and then GOUP BY tip in order to get the max value for each tip:
SELECT tip, MAX(nrreddordok) FROM table GROUP BY tip
If you just want values for A then you can use following query:
SELECT MAX(nrreddordok) FROM table WHERE tip = 'A'
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: Custom source, res and AndroidManifest location in Android project in Eclipse
- Next: Gunicorn and Supervisor error file does not have executable permissions
Related
Related Related
- 1
Get value based on max of a different column grouped by another column
- 2
get max date based on column value
- 3
Get records based on column max value
- 4
SQL inner join on a column based on max value from another column
- 5
get max value of column
- 6
Get MAX value from one column and MIN from another column
- 7
Get value of another column based on foreign key
- 8
How to assign a default value in a column based on another column's value?
- 9
How to assign a default value in a column based on another column's value?
- 10
How to assign a value for a column based on another column value in R?
- 11
How do I return max value in a non-aggregated sql query based on another column value
- 12
R - How to get value from a column based on value from another column of same row
- 13
How to get every value from one column to another column based on its corresponding value
- 14
Finding the max value from a column and populating another column based on the max value
- 15
updating column value based on another column value
- 16
How to Get Max Value and Return Other Column
- 17
How can I get the max value from one column where values match another column?
- 18
Grouping column indices of an array based on max value of another list in python
- 19
Grouping column indices of an array based on max value of another list in python
- 20
get all first occurences of a column based on the value of another column - matlab
- 21
Value of id corresponding to max value of another column
- 22
Value of id corresponding to max value of another column
- 23
Get max value of a column and id
- 24
Get the max value for a specific column
- 25
How can I get a list of all permutations of two column combination based on another column's value?
- 26
How can I get the corresponding value of a column based on an aggregate of another column?
- 27
How to get all values of a specific column based on a specific value in another column in R?
- 28
SQL how create a Boolean column based on the value of another column
- 29
How to find adjacent values in a column based on another column value in Sql
Comments