Posted by Marie-Christine Bechara on 08/16/06 12:16

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 ***

• Next in forum: Re: union all and order by problem
• Prev in forum: Re: clustered vs. non clustered
• Thread view: union all and order by problem

[Reply to this message]