SQL Sorting Data into a Template

Question

Not sure if this is possible, but there may be a creative approach ...

Given this data in SQL Server 2005:

AAA
AAA
in
In
the CCC
the CCC
DDD
DDD

How can I return a result set sorted by template as follows:

AAA
in
the CCC
DDD
AAA
in
the CCC
DDD

Answer 1

If your column was called "col" and your table was called "table", I would try something like this:

WITH Indexes AS (
    SELECT 
    ROW_NUMBER() OVER (PARTITION BY col ORDER BY col) as __row,
    col
    FROM table)
SELECT col
FROM Indexes
ORDER BY __row, col;

Answer 2

, , Oracle , ROWNUM .

:

• rownum modulo 2

, , .

Answer 3

Mysql if you have a table T (varchar); with the data you provided:

select @t:=a from T order by @t <> a;

works: -)