Re: SQL Puzzle

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Tue, 30 Nov 1999 12:13:25 -0500
Message-ID: <8b184skn6hfrvtg04aguh3emj1hsg0r9im@4ax.com>

A copy of this was sent to andreyNSPAM_at_bookexchange.net (NetComrade) (if that email address didn't require changing) On Tue, 30 Nov 1999 16:20:37 GMT, you wrote:

>Hi I have the table with the following records
>
>
>SQLWKS> SELECT TO_CHAR(price, '$99,999,999') , TO_CHAR(when_closed,
>'MM/DD')
> 2> FROM player_close
> 3> WHERE player_id = 1002
> 4> AND when_closed >= SYSDATE - 14
> 5>
>TO_CHAR(PRIC TO_CHAR(WHEN_CLOSED,'MM/DD')
>
>------------
>---------------------------------------------------------------------------
> $12,080,000 11/17

[snip]

>
> $12,590,000 sysdate
>
>basically moving up the date.
>
>Any suggestions?

ADD: order by when_closed desc

to the query....

>---------------
>Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417
>AOL: NetComrade ICQ: 11340726 remove NSPAM to email

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Nov 30 1999 - 11:13:25 CST