Issue
I am using this query
"select * from SomeTable group by SomeColumn"
It is returns list with accenting order, but i need to same order like in database.
For example the order in database is:
p
a
s
But result is:
a
i
p
The result need to be like distinct by CityEN but with all columns and order like 1.Paris 2.Amsterdam 3.Istanbul
Solution
In your statement, add this line to sort the results:
order by min(rowid)
Answered By - forpas
0 comments:
Post a Comment
Note: Only a member of this blog may post a comment.