Dubults ORDER BY

Vai ir iespeejams dubluts ORDER BY?

Man vajadziigs izvadiit visus topikus kur ir topic_type 3 ORDER BY time un peectam visus topikus kur topic_type 2, ORDER BY time utt..

Vai var taisiit kaadu tubulto ORDER BY ?

Komentāri:

#1 .... @ 2008.01.17 16:15

... where topic_type = 3 or topic_type = 2 order by topic_type desc, time asc/desc

#2 Nmy @ 2008.01.17 16:16

vai nu UNION vai nu pakaries.

#3 Johans2 @ 2008.01.17 16:32

#1 tu esi ģēnijs :)