I have a column that looks like this
How can I get the min and the max?
Here is the expected value where on the right side is the sorted one
Asked
Active
Viewed 102 times
0
-
2What's the expected result? – cdaiga Mar 28 '18 at 05:09
-
my expected result here is how can i get the lowest latlong ang also the highest lat long based on value – Nardong Bagsik Mar 28 '18 at 05:10
-
Did you try `MIN ()`,`MAX()` – D-Shih Mar 28 '18 at 05:11
-
i tried that but it gives me a wrong value – Nardong Bagsik Mar 28 '18 at 05:12
-
https://stackoverflow.com/questions/30746749/calculate-sum-max-avg-comma-separated-column-in-mysql This should help you. – TechnoCrat Mar 28 '18 at 05:18
-
@TechnoCrat thnx for the ref. but i think it is not based on lat and long – Nardong Bagsik Mar 28 '18 at 05:18
-
@NardongBagsik I just given you ref, you can make necessary changes according to your requirement. – TechnoCrat Mar 28 '18 at 05:26
-
What does max and min mean here, are we assuming this is longitude and latitude values? In your example it looks like it is only the first value that is relevant. – Joakim Danielson Mar 28 '18 at 05:29
-
this is the latitude and longitude – Nardong Bagsik Mar 28 '18 at 05:39
-
And...? What is max and mean, max latitude or is it the coordinates that is to be sorted and if so, how? – Joakim Danielson Mar 28 '18 at 05:42
-
sir based on the second pic thats how i need to sort it just only the min and max lat long – Nardong Bagsik Mar 28 '18 at 05:47
-
Ok, I understand. Then the accepted answer is wrong btw and you can just sort it like you sort any other column using "ORDER BY latlong" – Joakim Danielson Mar 28 '18 at 06:23
2 Answers
1
Select membername From
(Select membername,
substring_index ( membername,',',1)+substring_index ( membername,',',-1) as total
From Table1) T1
Inner Join
(
Select Max(total) total1,Min(total) total2 From (
SELECT membername,
substring_index ( membername,',',1)+substring_index ( membername,',',-1) as total
From Table1)T) T2
ON T1.total=T2.total1
OR T1.total=T2.total2
Live Demo
Jay Shankar Gupta
- 5,918
- 1
- 10
- 27
1
To sort the table according to the expected result in the question all you need is:
SELECT latlong
FROM someTable
ORDER BY latlong ASC
Joakim Danielson
- 43,251
- 5
- 22
- 52