SQL UNION-like query

[NewsBot]

I've got a table of items with prices. Nothing special really:

 

CREATE TABLE Variants (

[Name] nvarchar(50),

[MonthlyPrice] money

)

 

I need to get a query which gets all the entries that meet all the WHERE clauses, but such that all the items with a MonthlyPrice of 0 are placed below the items with a price.

 

So something like:

 

SELECT * FROM Variants WHERE (existingClauses) AND MonthlyPrice > 0 ORDER BY [Name] ASC

UNION

SELECT * FROM Variants WHERE (existingClauses) AND MonthlyPrice = 0 ORDER BY [Name] ASC

 

Is it possible to do it without a UNION? Because the table definition and existing clauses are already pretty complicated, and I don't want to have to duplicate the tables.

 

 

More...

 

View All Our Microsoft Related Feeds