SEO

#1 (**permalink**) 02-29-2008, 08:10 PM

SELECT *
FROM tblCountry
WHERE Country_Id = 26
UNION ALL
SELECT *
FROM tblCountry
WHERE Country_Id <> 26

--order by country_Name

i need to select country_id =26 and then the rest i want them ordered by
name.
if i put order by country_name, the country_id 26 isn't displayed as the
first one.
is there anyway to apply the order by only to the second select not the
whole?

*** Sent via Developersdex http://www.developersdex.com ***

#2 (**permalink**) 02-29-2008, 08:10 PM

ORDER BY CASE WHEN Country_Id = 26 THEN 1 ELSE 2 END, country_Name

Roy Harvey
Beacon Falls, CT

On 16 Aug 2006 12:16:01 GMT, Marie-Christine Bechara
<marie-christine.bechara@ifsal.com> wrote:

>
>
>SELECT *
> FROM tblCountry
> WHERE Country_Id = 26
> UNION ALL
> SELECT *
> FROM tblCountry
> WHERE Country_Id <> 26
>
>--order by country_Name
>
>i need to select country_id =26 and then the rest i want them ordered by
>name.
>if i put order by country_name, the country_id 26 isn't displayed as the
>first one.
>is there anyway to apply the order by only to the second select not the
>whole?
>
>*** Sent via Developersdex http://www.developersdex.com ***

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

union all and order by problem