performing an order by, and ignoring certain values.

[tekkerguy]

is there anyway to do an order by in sql, but ignoring certain values?


For example, order by "moneyinpocket"

But if a value is null, "ND", or 0, ignore them.

 

[SantaMufasa]

Tekker,

How about:

...order by nvl(moneyinpocket,0)...

...which says, "IF moneyinpocket IS NULL, THEN use '0' as the value of that tuple, otherwise use the value of moneyinpocket."

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[Turkbear]

Hi,
But that would not handle the examples:
"ND" or 0

Would a Decode maybe work here?

Order by decode(moneyinpocket,NULL,' ','ND',' ',0,' ',moneyinpocket)







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[SantaMufasa]

Good catch, Turk, I apparently read only what I wanted to read. . Yours is a better solution given the specifications.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[Turkbear]

Hi,
Its rare that you miss anything....







To Paraphrase:"The Help you get is proportional to the Help you give.."