complicated query

[billy83]

Hello. I have a table (auctions) that i store details about auctions. In this table i have two fileds. Maxbid and bidstart. I want to create an sql statement that will do the following. I want to select all the records and print them ordered by their maxbid. But if the maxbid is 0 then to take the price of bidstart instead. Is this possible?


something like
select * from auctions order by maxbid (but where you find that maxbid is 0 then take the price of the bidstart)

 

[r937]

order
by case when maxbid=0
then bidstart
else maxbid end

r937.com | rudy.ca

 

[gmmastros]

What database are you using. The solution to your question will likely depend on it.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[fredericofonseca]

select *
from auctions
order by
case
when maxbid = 0
then bidstart
else maxbid
end

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[billy83]

Thanks. It worked fine. I didn't know this case "thing". Thanks again!!