[eluser]Unknown[/eluser]
I am using sparks and want to UNION query. can any one suggest me how to write it .
example table:
id name color
1 nilesh blue
2 manoj red
3 shrikant red
4 shafiq blue
5 sharad blue
i want blue record first after red record like bellow:
id name color
1 nilesh blue
2 shafiq blue
3 sharad blue
4 shrikant red
5 manoj red