[RESOLVED] access problem

[ledaker]

Hi, i have table with column that takes country name else it takes "other" value my question is how i can retrieve rows grouped by country name and the rows with country name equal to "other" are in the end of selection

[Homogenn]

Hi, i have table with column that takes country name else it takes "other" value my question is how i can retrieve rows grouped by country name and the rows with country name equal to "other" are in the end of selection

Easiest way would probably be

SELECT *
FROM tableA
WHERE columnA <> 'Other'
ORDER BY columnA asc

UNION

SELECT *
FROM tableA
WHERE columnA = 'Other';

[davide++]

Hi all.

This query doesn't work beacause you cannot add the ORDER BY clause into UNION. Probably there isn't a way to get what ledaker wants using only a query.

[ledaker]

Hi all.

This query doesn't work beacause you cannot add the ORDER BY clause into UNION. Probably there isn't a way to get what ledaker wants using only a query.

davide++ has reason this query doesnt work, please other solution

[Homogenn]

Sorry, you're right, try this instead

SELECT *, '1' AS OrderBy
FROM tableA
WHERE columnA <> 'Other'

UNION

SELECT *, '2' AS OrderBy
FROM tableA
WHERE columnA = 'Other'

ORDER BY OrderBy ASC;

Just note that you'll get the extra field out "OrderBy" with values '1' or '2'.

[ledaker]

thank you