Timeline for SQL Preserve the Order in group by
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 7, 2019 at 9:39 | history | edited | Randi Vertongen | CC BY-SA 4.0 |
edited body
|
| May 7, 2019 at 9:30 | vote | accept | kkakadiya | ||
| May 7, 2019 at 9:29 | comment | added | kkakadiya | thanks @Randi Vertongen for the help. there is nothing like no solution. I got the solution from above your partial query. here is my query. select route_id,fixcode,fixdescription, MIN(id) as minid from route_fixcodes where route_id = 995063 GROUP BY route_id,fixcode,fixdescription Order by minid | |
| May 7, 2019 at 8:34 | comment | added | kkakadiya | above solution doesn't work.I don't want my output in any of the order. I want output as it displayed in screenshot | |
| May 7, 2019 at 7:53 | history | answered | Randi Vertongen | CC BY-SA 4.0 |