order by - sorting 1

[puitar]

Hello,

I have a sql statement..

select * from Properties where PropertyType = 'Land' order by 'TotalPrice'

The client wants to display certain records first eg (where agent = 'HeadOffice') and then display the rest.

Can this be done with sql or do I have to do it with two seperate queries?

Thanks

 

[SonOfEmidec1100]

This should help. I assume TotalPrice is a column name - remove the quotes, otherwise it will be treated as a string value.

select * from Properties where PropertyType = 'Land'
 order by case when agent = 'HeadOffice' THEN 0 ELSE 1 END,  TotalPrice

 

[puitar]

Thanks SonOfEmidec1100

Works a treat