sql - Ordering Select clause result in specific way -
I need help writing a Choose clause query.
For example, say I have such a query:
select value from some_table command by ass ascending;
As a result, I get this:
1 2 3 4 5 6 7 8 9 10
But one The special query that I want to write is the one that will give me value sorted but after 5 8 will put .
>This means that I need a value to be out of the Regular order.
It can be described in another way. To say I have two groups of numbers (example): A = {a | 1 & lt; = A & lt; = 118, a! = 78} b = {b | B> 118} I have Group C = AUBU {78} and I need all sorted values like "A, 78, B"
is an integer, you can:
from SELECT * in the case of tbl ORDER when value = 5 THEN 8.5 ELSE value END
Comments
Post a Comment