Re: nvl question

On Sat, 30 Jun 2001, P.J. wrote:
> Try this
> select distinct tab1.col1
> from tab1
> order by tab1.col1 desc

I'm sorry, I didn't make myself clear.

> > My select returns null as the last value and I would like it to be first?

I meant I want the rows ordered alphabetically AND have null listed first. That's why I thought about NLV.

Thank you,
kazelot Received on Sat Jun 30 2001 - 15:12:59 CDT